Book description
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.
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewers
- Acknowledgments
- Introduction
-
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: User-Defined 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
- Part 4: Query Life Cycle
-
Part 5: Practical Troubleshooting
- Chapter 27: System Troubleshooting
- Chapter 28: Extended Events
- Part 6: Inside the transaction log
- Part 7: In-Memory OLTP Engine
-
Part 8: Columnstore Indexes
- Chapter 33: In-Memory OLTP Programmability
- Chapter 34: Introduction to Columnstore Indexes
- Chapter 35: Clustered Columnstore Indexes
- Index
Product information
- Title: Pro SQL Server Internals
- Author(s):
- Release date: June 2014
- Publisher(s): Apress
- ISBN: 9781430259626
You might also like
book
Pro SQL Server Internals, Second Edition
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components …
book
Guru's Guide to SQL Server Architecture and Internals, The
"I can pretty much guarantee that anyone who uses SQL Server on a regular basis (even …
book
Pro SQL Server Administration
This book brings SQL Server administration into the modern era with strong coverage of hybrid cloud …
book
Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL …