Inside Microsoft SQL Server 7.0 Kalen Delaney Based PDF

“This book is a must-have for every SQL Server developer’s book shelf… worth its weight in gold.” —John P. Mitchell DevX.com With the innovations in Microsoft® SQL Server™ 7.0, organizations like yours get a powerfully enhanced tool for turning enterprise information into business results. In this essential companion to version 7.0, two of the most knowledgeable authorities on SQL Server technology step inside the reengineered SQL Server engine to reveal how underlying system structure and behavior affect application development. Use this in-depth, expert investigation—plus the ready-to-load evaluation copy of SQL Server 7.0—to understand how to create high-performance data warehousing, transaction processing, and decision-support applications that scale as far as your vision for the enterprise. • Explore critical new areas of functionality—including dynamic memory sizing and integrated cache, automatic statistics management, and full row-level locking • Use sophisticated built-in tools—including Query Analyzer and SQL Server Profiler—to simplify system administration and optimize performance • Dramatically simplify application development with Transact-SQL; extend functionality with batches, transactions, stored procedures, and triggers • Examine new query processing techniques—such as multiple indexes and hash and merge joins—and data manipulation capabilities, including parallel queries • Exploit SQL Server’s integration with Microsoft Office 2000, the Visual Studio® development system, and the BackOffice® family • Understand your application design options by reviewing a full chapter of practical examples An electronic version of this book is available on the companion CD.