Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features

Chapter 2: Database Architecture

Table 2–1: Page Types Used by SQL Server Databases

Table 2–2: The Bit States for Reporting the Current State of an Extent

Chapter 4: Connecting to and Administering the Database Engine

Table 4–1: Default Network Address that SQL Server 2005 Monitors

Chapter 5: Security

Table 5–1: Fixed Server Roles

Table 5–2: Fixed Database Roles

Chapter 7: SQL Server Disaster Recovery

Table 7–1: SQL Server 2005 Recovery Models

Table 7–2: The backup types offered by SQL Server’s online backup architecture

Chapter 8: Distributed Database Architecture

Table 8–1: Replication Options

Chapter 10: Transact-SQL Primer

Table 10–1: Arithmetic Operators

Table 10–2: Bitwise Operators

Table 10–3: Operand Data Types

Table 10–4: Comparison Operator

Table 10–5: Logical Operators

Table 10–6: Unary Operators

Table 10–7: Base Data Types in Order of Preference

Table 10–8: Decimal and Numeric types

Table 10–9: Float and Real

Table 10–10: Data Type Synonyms

Table 10–11: Mathematical Functions

Table 10–12: Aggregate Functions

Table 10–13: Date and Time Functions

Table 10–14: Values for Datetime

Chapter 11: Understanding the SQL Server Common Language Runtime

Table 11–1: Abridged Version of the CLS

Chapter 17: Working with Transactional Data

Table 17–1: Isolation Levels

Table 17–2: Lock Granularity

Table 17–3: Lock Modes

Table 17–4: Lock Compatibility Matrix. Key: IS=Intent Shared, S=Shared, U=Update, IX=Intent Exclusive, SIX=Shared with Intent Exclusive, X=Exclusive

Table 17–5: Statements That Require Transactions in Implicit Mode

Chapter 18: Monitoring SQL Server

Table 18–1: Options for Monitoring SQL Server *Using SQL Server Profiler Stored Procedures

Table 18–2: Server Objects and Counters

Table 18–3: Objects and What They Are Used For

Table 18–4: Thresholds for a Minimum Set of System Counters

Table 18–5: Tracking SQL Server Performance

Table 18–6: The DBCC Statement Categories