Synopsis
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
À propos de l?auteur
Currently a Microsoft product unit manager, Ron Soukup is one of the original members of the SQL Server team at Microsoft. He is a 17-year veteran of computer and database systems design, including 10+ years leading Microsoft's SQL Server development group. Kalen Delaney has worked extensively with SQL Server since 1987 and brings more than 20 years' experience in technical support and education to this book. As a consultant to Microsoft, Kalen has developed advanced training materials on SQL Server, including curriculum supporting version .7.0. She is a columnist for SQL Server Magazine.
Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.