MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

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