Microsoft SQL Server 2012 InternalsDive 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:
|
Contents
Contents at a glance Introduction | |
SQL Server 2012 architecture and configuration | |
Conclusion | |
The SQLOS | |
Databases and database files | |
Special databases | |
Logging and recovery | |
Table storage | |
Special storage | |
Special indexes | |
Query execution | |
The Query Optimizer | |
Plan caching and recompilation | |
Transactions and concurrency | |
DBCC internals | |
Index | |
internals and management | |
Other editions - View all
Common terms and phrases
actual allocated B-tree base table batch bitmap buffer BYTE Record cache catalog view Chapter clustered index clustering key col1 col2 collation columnstore index compression configuration constraint contains CREATE INDEX CREATE TABLE data type database DBCC default DELETE disk example execution Extended Events Figure filegroup FILESTREAM data filter full-text index function hash join hash table includes Index Scan index seek indexed view INNER JOIN input INSERT internal leaf level log backup log file memory merge join metadata multiple nested loops join node nonclustered index NULL number of rows object offset operator option output parallel parameter partition performance predicate PRIMARY KEY processor Query Optimizer query plan recovery recovery model returns schema SELECT session snapshot sparse columns spatial index specified SQL Server 2012 SQL Server instance storage stored subquery T-SQL tempdb thread transaction log update varchar VLFs XML index