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
Introduction | |
Acknowledgments | |
The SQLOS | |
Memory | |
SQL Server Resource Governor | |
SQL Server 2008 Configuration | |
SQL Server Configuration Settings | |
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 ALTER TABLE B-tree batch BYTE Record bytes catalog view chapter clustered index clustering key col1 col2 collation command Compiled Plan compression configuration consistency checks constraint contains CREATE TABLE data row data type DBCC CHECKDB default DELETE disk enabled error event example exclusive lock execution filegroup filestream data filter function hint indexed view INSERT internal isolation level leaf level Level 16 LOB data log backup log file memory metadata multiple nonclustered index NULL Object ID offset Online operations option output parameter parameterized performance plan cache plan guide PRIMARY KEY Query Optimizer query plan query processor recompilation record recovery model resource row-overflow scan schema Serializable slot Snapshot isolation space sparse columns specified SQL Server 2008 SQL Server instance statement statistics storage stored procedure T-SQL tempdb transaction log update varchar



