Backup Device SQL Server object, 547
BACKUP function, 566
Backup Job, SQL Server Agent, 243
BACKUP KEYS function, 566
backups.
See also disaster recovery
creating on primary server, 233
data, 178–182
log shipping process for, 236
SQL Server Backup General page, 195
for very large databases, 263
base class library, SQL Server, 351
base dates, 302
BATCHSIZE arguments, 432–433, 435
BEGIN COVERSATION TIMER clause, 567
BEGIN DIALOG CONVERSATION clause, 567
BEGIN DISTRIBUTED TRANSACTION clause, 567
BEGIN TRANSACTION statements, 60, 500, 567
BEGIN…END function, 566
benchmarks, Transaction Processing Performance Council, 50–51
BETWEEN clause, 567
BETWEEN logical operator, 298
bigint data type, 581
bigint integers, 301
BINARY BASE64, XML, 470, 516
binary constants, 292
binary data types, 304, 567
binary string-based data types, 296
BINARY_CHECKSUM command, 567
biometric devices, 101
bit constants, 292
bit integer data type, 567
bit integers, 301
bitmaps, 42–44
Bitwise AND (&) operator, 560
Bitwise Exclusive OR (^) operator, 560
Bitwise NOT (~) operator, 560
Bitwise NOT (~) unary operator, 299
bitwise operators, 296
Bitwise OR (|) operator, 560
blocking locks, 555
blocks, 497
body, SOAP message, 528–529
bottlenecks, 539, 552–555
bound connections, 497
bound controls, 404
branching statements, 325
BREAK keyword, 327, 567
BROWSE argument, 469
B-tree indexes, 45, 174
BU (bulk update) locks, 492–493, 495
buffer cache, 56–57
Buffer Manager SQL Server object, 547
buffer pages, 63–64
BUILTIN\Administrators, 119, 275, 277
Bulk Changed Map page, 39
BULK INSERT statements, 430–435, 567
BATCHSIZE argument, 432–433
data source, 432
FIELDTERMINATOR argument, 433
FIRSTROW/LASTROW argument, 433–434
FORMATFILE argument, 435
MAXERRORS argument, 434
ORDER argument, 434
overview, 430–432
TABLOCK argument, 434–435
target databases and tables, 432
and transactions, 435
triggers and constraints, 435
bulk update (BU) locks, 492–493, 495
BULK_LOGGED option, ALTER DATABASE statements, 157–158
bulkadmin fixed server role, 122
bulk-logged recovery models, 185–186, 435
business rules and data integrity, 357–359
BY expression, 468–469
Bytes Total/sec values, 554