Master the inner workings of today’s premier relational database management system with this official guide to the SQL Server 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to understand how SQL Server internal structures affect application development and functionality. Its extensive details about the latest product enhancements, updated installation and administration, and its development advice can help you create high-performance data-warehousing, transaction-processing, and decision-support applications that will scale up for any challenge.

Topics covered include:

Evolution, architecture, and toolset: The history of SQL Server since 1989, an architectural overview, and a comprehensive tour of its tools and features
Planning and deployment: Everything you need to know about installation and deployment issues such as multiple instances, Super Sockets, and upgrades
Databases, files, tables, and data: How to create, modify, back up, and restore databases, files, and tables; and how to query and modify data
Built-in development tools: Using Query Analyzer and SQL Server Profiler to simplify system administration and optimize performance; programming with Transact-SQL; and extending functionality with batches, transactions, stored procedures, and triggers
Query-processing techniques: Multiple indexes, hash and merge joins, and data-manipulation capabilities such as parallel queries
Internal architecture: Low-level details of data and index-page structures, locking mechanisms, optimization, and plan caching
Integration with other tools: Usage with Microsoft Office 2000, Visual Studio development system, and the BackOffice server familyINCLUDED ON TWO CD-ROMS!
A 120-day evaluation copy of Microsoft SQL Server 2000 Enterprise Edition
A searchable electronic copy of the book
Sample scripts
White papers and articles
Tools and utilities

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

About the Author

Over 60 SQL Server MVPs contributed to this book, which was assembled and edited by Kalen Delaney and SQL Server legends Louis Davidson (Database Design and Architecture), Greg Low (Business Intelligence.), Brad McGhee (Performance Tuning and Optimization), Paul Nielson (Database Development), and Paul Randal and Kimberly Tripp (Database Administration.)

"About this title" may belong to another edition of this title.

Store Description

In 2002, World of Books Group was founded on an ethos to do good, protect the planet and support charities by enabling more goods to be reused. Since then, we've grown into to a global company pioneering the circular economy. Today, we drive the circular economy through three re-commerce brands: - Wob: Through Wob, we sell. We provide affordable, preloved books and media to customers all over the world. A book leaves our collection of over seven million titles and begins a new chapter every two seconds, enabling more goods to be reused. - Ziffit: Through Ziffit, we buy. We give people around the world the opportunity to contribute to the circular economy, earn money and protect the planet, by trading their unwanted books and media. - Shopiago: Through Shopiago, we help others. By sharing the technology that has grown World of Books Group into the business it is today, we?re helping charities increase revenue and reduce waste through re-commerce.

Visit Seller's Storefront

Seller's business information

World of Books Ltd
Mulberry House, Woods Way Trading Estate, Goring-By-Sea, BN12 4QY, United Kingdom

Sale & Shipping Terms

Terms of Sale

WorldofBooks.com fully embraces the AbeBooks terms and conditions and we will do
what we can to resolve any issues.

Shipping Terms

Orders ship within 2 business days. Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.