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: <ul>
<li>Evolution, architecture, and toolset: The history of SQL Server since 1989, an architectural overview, and a comprehensive tour of its tools and features</li> <li>Planning and deployment: Everything you need to know about installation and deployment issues such as multiple instances, Super Sockets, and upgrades</li> <li>Databases, files, tables, and data: How to create, modify, back up, and restore databases, files, and tables; and how to query and modify data</li> <li>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</li> <li>Query-processing techniques: Multiple indexes, hash and merge joins, and data-manipulation capabilities such as parallel queries</li> <li>Internal architecture: Low-level details of data and index-page structures, locking mechanisms, optimization, and plan caching</li> <li>Integration with other tools: Usage with Microsoft Office 2000, Visual Studio development system, and the BackOffice server familyINCLUDED ON TWO CD-ROMS!</li> <li>A 120-day evaluation copy of Microsoft SQL Server 2000 Enterprise Edition</li> <li>A searchable electronic copy of the book</li> <li>Sample scripts</li> <li>White papers and articles</li> <li>Tools and utilities</li> </ul>
 For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Inside Microsoft SQL Server 2000

Computers & Technology

Kalen Delaney

Programming

Microsoft Press

Dig into the internals of tuning and optimization features in SQL Server 2005—with insights from leading SQL Server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples to help you enable efficient, effective queries—and optimize database performance. Discover how to: Create a baseline and monitor workload by using System Monitor and DMVs Design, manipulate, and manage traces to isolate database performance issues Audit user activity by using built-in default, black box, and Common Criteria traces Analyze query execution using scans and seeks, joins, aggregations, unions, and parallelism Generate efficient and cost-effective queries using cached plans or new plans Detect and resolve locking, blocking, and deadlocking concurrency issues Use best practices to diagnose and troubleshoot response time, throughput, and scalability issues PLUS—Includes Transact-SQL code samples and on the Web

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

Adam Machanic

Sunil Agarwal

Craig Freedman

Ron Talmage

Networking & Cloud Computing

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: 
<ul>
<li>What happens internally when SQL Server builds, expands, shrinks, and moves databases</li> <li>How to use event tracking—from triggers to the Extended Events Engine</li> <li>Why the right indexes can drastically reduce your query execution time</li> <li>How to transcend normal row-size limits with new storage capabilities</li> <li>How the Query Optimizer operates</li> <li>Multiple techniques for troubleshooting problematic query plans</li> <li>When to force SQL Server to reuse a cached query plan—or create a new one</li> <li>What SQL Server checks internally when running DBCC</li> <li>How to choose among five isolation levels and two concurrency models when working with multiple concurrent users</li> </ul>

Microsoft® SQL Server® 2008 Internals (Pro - Developer)

Conor Cunningham

Paul S. Randal

Benjamin Nevarez

Kimberly L. Tripp

Dive deep inside the architecture of SQL Server 2012 
 Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator. 
 Discover how to: 
<ul>
<li>Dig into SQL Server 2012 architecture and configuration </li>
<li>Use the right recovery model and control transaction logging </li>
<li>Reduce query execution time through proper index design </li>
<li>Track events, from triggers to the Extended Event Engine </li>
<li>Examine internal structures with database console commands </li>
<li>Transcend row-size limitations with special storage capabilities </li>
<li>Choose the right transaction isolation level and concurrency model </li>
<li>Take control over query plan caching and reuse </li>
</ul>

Microsoft SQL Server 2012 Internals: Professional

Bob Beauchemin

Jonathan Kehayias

Microsoft Pr

See the best price to sell, buy, or rent books by Kalen Delaney. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Kalen Delaney