B


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




Microsoft SQL Server 2005. The Complete Reference
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
Year: 2006
Pages: 239

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net