Read the Most Updated Knowledge of SQL Server 2008 From SQL Server Internals Guru, Kalen Delaney
Read the Most Updated Knowledge of SQL Server 2008
From SQL Server Internals Guru, Kalen Delaney
Kalen Delaney, an expert of SQL Server, is a regular contributor of SQL Server Magazine and author for Inside SQL Server series. Recent book is SQL Server 2008 Internals. This book contains 2 parts.
Part 1 :
Heaps and B-trees
Clustered indexes
Nonclustered indexes
Index internals
Covering indexes and included columns
Index metadata
Fragmentation
Rebuilding indexes
Filtered indexes
Part 2 :
Query processing overview
Plan management and reuse
Causes of recompilation
Forcing recompilation
Optimization and compilation hints
Optimizer metadata
If you are interested to know inner working of SQL Server (is a foundation as true performance tuner), it is a good investment for your knowledge and stand out of crowd.