1381
Index
rollback, DDL triggers, 906
save points, 1054
SELECT, 1049–1050
SQL Profi ler, 922
triggers, 880–881, 886–891
UPDATE, 1049–1050
versions, 1048
write confl icts, 1085
Xact_Abort, 1052
Xact_State(), 1051
transaction logs
architecture, 1089–1093
backup, 565–566
bulk-loaded recovery model, 554
CDC, 954
checkpoints, 564–565
database mirroring, 688
DBCC, 599
durability, 550
log shipping, 668–669
recovery, 548, 549, 563–567,
1093
shrinking, DBCC, 601–603
simple recovery model, 567
truncating, 567
transactional integrity, 19, 1070–
1086
recovery planning and, 547
Transact-SQL (T-SQL), 17
ANSI, 389
batches, 390–391
Query Editor, 102–103
BULK INSERT, 425–428
bulk operations, 424–428
Change Tracking, 948
comments, 392–393
data compression, 1106
debugging, 397, 409
decryption, 855–856
distributed queries, 378
DML, 389
encryption, 855–856
end-of-line returns, 392
error handling, 412–424
RAISERROR, 414–418
TRY...CATCH, 418–424
fatal errors, 424
FETCH, 410–412
formatting, 392–393
GOTO, 402–403
IF, 399–401
iterative code, 25
joins, 217, 222
legacy error handling, 412–414
lightweight pooling, 493
linking, 368, 371–373log shipping confi guration,
675–676
metadata, 409–410
OFFSET, 410–412
OUTPUT, 320
PAGE_VERIFY, 526–527
PowerShell module cmdlets, 784
priority boost, 492
procedural fl ow, 399–403
programming, 389–429
Query Editor, 101
recovery, 574–579
recovery interval, 529
scripts, 793
Generate and Publish Scripts
Wizard, 808
Server Audit Specifi cation, 972
SMOs, 786
SNAC, 74, 75
SQL Audit, 970
SSMS, 81, 82
stored procedures, 432
system functions, 404–405
table variables, 407–408
temporary tables, 406–407
transaction log backup, 565
T-SQL for XML clause, 340
variables, 393–399
WHILE, 401–402
Transfer Database Objects Tasks,
1173
Transfer Error Messages, 1173
Transfer Jobs, 1173
Transfer Logins, 1173
Transfer Master Stored Procedures,
1173
Transfer Objects, 1173
transformations, 1179–1182
Transmission Control Protocol
(TCP), 693
Transmission Control Protocol/
Internet Protocol (TCP/
IP), 72
database mirroring, 693
installation, 66–67
ports, 73
SNAC, 73
Transparent Data Encryption (TDE),
37, 854
backup, 854
triggers
AFTER, 880–883
multiple, 895–896
recursive, 893
ALL SERVER, 901
ALTER, 881audit trail, 892
concurrency, 26
confi guration, 521–522
CREATE, 881
creating, 879–907
data integrity, 19, 880
data replication, 728
DATABASE, 901
DDL, 881, 894–895, 901–906
creating and altering,
901–902
developing, 904–906
enabling and disabling, 904
ENCRYPTION, 903
EventData(), 904–905
EXECUTE AS, 903
managing, 901–904
object_id(), 904
preventing database object
changes, 906
removing, 904
scope, 902–903
security, 903–904
sys.server_triggers, 904
sys.triggers, 904
transaction rollback, 906
DELETE, 879
disabling, 885
DML, CDC, 961
DROP, 881
EXECUTE AS, 886
INSERT, 879, 895
INSTEAD OF, 880, 883–884
interaction of multiple, 891–896
limitations, 884–885
lists, 885–886
logical tables, 888–889
multiple-row, 889–891
nested, 522, 892–893
Object Explorer, 882
Security, 91
organization, 891–892
query recompiles, 1045
recursive, 522, 893–895
RETURN, 894
row-level security, 862, 874–875
runaway, 894
security, 886, 892
server confi guration, 471
stored procedures, 894
transactions, 880–881, 886–891
aggregations, 896–900
UPDATE, 879
UPDATE(), 886–887
TRIPLE_DES, 857
trivial plans, 1045bindex July 23, 2012 2:44 PM V1bindex.indd 1381bindex.indd 1381 7/31/2012 10:40:00 AM7/31/2012 10:40:00 AM
http://www.it-ebooks.info