Microsoft SQL Server 2008 InternalsDelve inside the core SQL Server engine--and put that knowledge to work--with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you'll gain the deep knowledge you need to exploit key architectural changes--and capture the product's full potential. Discover how SQL Server works behind the scenes, including:
|
Contents
SQL Server 2008 Architecture and Configuration | 1 |
The Scheduler | 20 |
Change Tracking Tracing and Extended Events | 75 |
Copyright | |
42 other sections not shown
Other editions - View all
MICROSOFT SQL SERVER 2008 INTERNALS Kalen Delaney,Paul S.Randal,Kimberly L.Tripp,Conor Cunningham,Adam Machanic No preview available - 2011 |
Common terms and phrases
actually affinity mask alloc unit ALTER DATABASE B-tree batch buffer pool BYTE Record bytes catalog view Change Tracking chapter checkpoint clustered index col2 collation compression computed configuration consistency checks contains Cost CREATE TABLE data files data type DBCC CHECKDB default DELETE disk enabled error event example execution filegroup filestream data filter function indexed view INSERT internal isolation level lock log backup log file Management memory metadata Microsoft Microsoft SQL Server mode multiple node nonclustered index NULL Object ID offset operations option output parameter partition performance PRIMARY KEY Query Optimizer query plan recompilation record recovery scan scheduler schema SELECT session Snapshot isolation space sparse columns specified SQL Server 2008 SQL Server Books SQL Server instance SQL Trace storage stored procedure T-SQL tempdb thread transaction log update varchar VLFs Windows workload group