http://worldcat.org/entity/work/id/1927210495

Pro SQL Server Internals

Explains how different SQL Server components work internally and how they communicate with each other. Presents a large number of examples that will show how various design and implementation decisions affect the behavior and performance of systems. Covers multiple SQL Server versions from SQL Server 2005 through SQL Server 2014. The book covers new SQL Server 2014 features including the new Cardinality Estimator. Topics covered include: designing efficient database schema, indexing, and transaction strategies and solutions utilizing SQL Server as the database backend; how various database objects and technologies are implemented internally and when they should or should not be used; how SQL Server executes queries and works with data and transaction logs; troubleshooting and addressing design, concurrency, and performance issues in systems; improving system availability and manageability and reduce implementation costs with data partitioning; designing efficient disaster recovery and high-availability strategies for systems; improving the performance of OLTP and data warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine (codename Hekaton) and Clustered Columnstore Indexes. This book is for developers and database administrators.

Open All Close All