balanced tree indexes, 305, 464. See also clustered indexes, non-clustered indexes
baselines
creating performance baselines, 380
exercise comparing clustered indexes, non-clustered indexes, and indexed views against baseline, 330
exercise creating performance baseline for queries, 324–325
Basic authenticationz, 20
BEGIN DISTRIBUTED TRANSACTION statement, 267
BEGIN TRANSACTION statement, 244
Body, of XQuery expressions, 82
bookmark lookup, indexes, 467
bottlenecks, I/O and CPU bottlenecks, 384
B-Tree (Balanced Tree) indexes, 305, 464. See also clustered indexes, non-clustered indexes
buffer cache
defined, 410
determining object data stored in, 424
buffer pool (BPool), 447
built-in functions
aggregate functions, 61
SQL Server 2005, 61