Pro SQL Server Internals

Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems. Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You'll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use. Pro SQL Server Internals does the following: Explains how to design efficient database schema, indexing, and transaction strategies. Shows how various database objects and technologies are implemented internally and when they should or should not be used. Demonstrates how SQL Server executes queries and works with data and transaction logs. Pro SQL Server Internals peels back the covers of SQL Server, explaining in detail how the database works in a way that allows you to immediately apply this knowledge to day-to-day tasks. It uncovers the product internals and, more importantly, demystifies how internal implementation affects your system. Youll learn how SQL Server stores its data and along with that, how to create efficient, fast, cost-effective indexes. Youll see why there is locking and how to troubleshoot and avoid concurrency issues. Youll discover how SQL Server implements various database object types and what their pros, cons and best use cases are. Knowledge of SQL Server internals is crucial when you want to get the most from the product. It helps to understand how various design and implementation decisions affect database behavior and performance as well as how to efficiently troubleshoot and pinpoint problems in existing systems. With Pro SQL Server Internals, you have your roadmap to understanding the depth and power of the SQL Server database. Pro SQL Server Internals: \* Explains how to design efficient database schema, indexing and transaction strategies \* Shows how various database object types are implemented internally \* Demonstrates how SQL Server works with transaction logs What youll learn \* Design efficient database schema and indexing strategies \* Understand pros, cons and best use-cases of the various database object types and technologies \* Troubleshoot locking, blocking and performance issues in the systems \* Design efficient transaction strategies \* Get familiar with query life cycle and potential issues with plan cache and parameterization \* Design efficient backup and high availability strategies Who this book is for Pro SQL Server Internals is a book for developers and database administrators who want to design, develop and maintain systems in a way that gets the most from SQL Server. This book is for professionals who wish to understand what happens under the hood when a particular decision is made and how that affects the system. Pro SQL Server Internals is an excellent choice for people who prefer to understand and fix the root cause of the problem rather than applying a band aid to it. 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