B

BACKUP (reserved word), 460

Ballmer, Steve (Microsoft), 24

batch directives, 66

BCNF (Boyce-Codd Normal Form), 32–33

BEFORE (reserved word), 465

BEGIN (reserved word), 460, 462

Beginning SQL Server 2005 Programming (Viera), 1

benchmarking subqueries, 291–293

best practices for subqueries, 291–293

BETWEEN operator, 145

BETWEEN (reserved word), 460, 462

biased estimate of variance, 211

BINARY (reserved word), 465

BINARY_CHECKSUM() function, 473

BIT (reserved word), 462, 465

BIT_LENGTH (reserved word), 462

BLOB (reserved word), 465

Books Online

OSQL utility, 70–72

overview, 49, 69

updating, 69

Bool, George (logical gates), 141

BOOLEAN (reserved word), 465

BOTH (reserved word), 462, 465

Boyce, Raymond F. (relational database design), 31

Boyce-Codd Normal Form (BCNF), 32–33

BREADTH (reserved word), 465

BREAK (reserved word), 460

breaking normalization rules, 42

bridge table, 39

BROWSE (reserved word), 460

budget constraints, 400

buffer cache, 44

BULK (reserved word), 460

business cases for subqueries, 293–296

Business Intelligence Development Studio, 73, 97–98

business logic, processing, 378–380

BY (reserved word), 460, 462