Apress

Pro SQL Server Internals

By Dmitri Korotkevitch

Pro SQL Server Internals Cover Image

Pro SQL Server Internals explains how SQL Server works focusing on how internal implementation affects your database operations.

Full Description

  • ISBN13: 978-1-4302-5962-6
  • User Level: Intermediate to Advanced
  • Publishing June 24, 2014, but available now as part of the Alpha Program
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $59.99
  • eBook Price: $41.99

Related Titles

Full Description

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. You’ll learn how SQL Server stores its data and along with that, how to create efficient, fast, cost-effective¬†indexes. You’ll see why there is locking and how to troubleshoot and avoid concurrency issues. You’ll 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 you’ll 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.

Table of Contents

Table of Contents

Part 1 – Tables and Indexes
•        Chapter 1: Data storage internals
•        Chapter 2: Tables and Indexes – Internal Structure and Access Methods
•        Chapter 3: Statistics 
•        Chapter 4: Special Indexing and Storage Features
•        Chapter 5: Index fragmentation
•        Chapter 6: Designing and tuning the indexes 

Part 2: Other things that matter
•        Chapter 7: Constraints
•        Chapter 8: Triggers
•        Chapter 9: Views 
•        Chapter 10: Functions 
•        Chapter 11: XML 
•        Chapter 12: Temporary Tables 
•        Chapter 13: CLR
•        Chapter 14: CLR types 
•        Chapter 15: Data partitioning 
•        Chapter 16: System design considerations 

Part 3: Locking, Blocking and Concurrency
•        Chapter 17: Lock types 
•        Chapter 18: Troubleshooting Blocking issues
•        Chapter 19: Deadlocks 
•        Chapter 20: Lock Escalations 
•        Chapter 21: Optimistic isolation levels 
•        Chapter 22: Application locks 
•        Chapter 23: Schema locks 
•        Chapter 24: Designing transaction strategies 

Part 4: Query Life Cycle  
•        Chapter 25: Query Optimization and Execution
•        Chapter 26: Plan Caching

Part 5: Practical Troubleshooting 
•        Chapter 27:  System Troubleshooting
•        Chapter 28: Extended events

Part 6: Inside the transaction log 
•        Chapter 29: Transaction Log Internals 
•        Chapter 30: Designing a Backup Strategy 
•        Chapter 31: Designing a High Availability Strategy 

Part 7: In-Memory OLTP Engine
•        Chapter 32: Hekaton (In Memory OLTP Engine)

Part 8: Columnstore Indexes
•        Chapter 33: Columnstore Indexes
•        Chapter 34: Introduction to Columnstore indexes
•        Chapter 35: Clustered Columnstore indexes 

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

No errata are currently published