Microsoft® SQL Server® 2012 Bible

1087 Chapter 47: Managing Transactions, Locking, and Blocking 47 Application Locks Application locks open up the whole world of ...

1088 Part VIII: Performance Tuning and Optimization Note two minor differences from the way application locks are handled by SQL ...

1089 Chapter 47: Managing Transactions, Locking, and Blocking 47 Brittany presses the Save and Close button, and her data is se ...

1090 Part VIII: Performance Tuning and Optimization Database Beginning State Before the transaction begins, the database is in a ...

1091 Chapter 47: Managing Transactions, Locking, and Blocking 47 SellEndDate = '12/31/2003' WHERE ProductID = '1001' UPDATE Prod ...

1092 Part VIII: Performance Tuning and Optimization In the seventh step of a transaction, the code closes the transaction: COMMI ...

1093 Chapter 47: Managing Transactions, Locking, and Blocking 47 Transaction-Log Rollback If the transaction is rolled back, the ...

1094 Part VIII: Performance Tuning and Optimization Make sure you consider the following points when designing your application ...

1095 Chapter 47: Managing Transactions, Locking, and Blocking 47 SQL Server 2012 Distributed Replay New in SQL Server 2012 is Di ...

c47.indd 1096c47.indd 1096 7/31/2012 10:23:34 AM7/31/2012 10:23:34 AM http://www.it-ebooks.info ...

1097 CHAPTER 48 Data Compression IN THIS CHAPTER Understanding Compression Reducing I/O Applying Database Compression Procedures ...

1098 Part VIII: Performance Tuning and Optimization Don’t confuse data compression with backup compression — the two technologie ...

1099 Chapter 48: Data Compression 48 choose compression wisely. More specifi cally, data that contains the following data patter ...

1100 Part VIII: Performance Tuning and Optimization ber of fi xed-length columns and the actual length of the data, this level m ...

1101 Chapter 48: Data Compression 48 written to an anchor row at the beginning of each page. This method is repeated for all sub ...

1102 Part VIII: Performance Tuning and Optimization As demonstrated, depending on the commonality of the data set, prefi x compr ...

1103 Chapter 48: Data Compression 48 If the object is row compressed, or page compressed (which automatically includes row com- ...

1104 Part VIII: Performance Tuning and Optimization ■ (^) The Data Compression Wizard, found in Object Explorer (Context menu ➪ ...

1105 Chapter 48: Data Compression 48 The result displays the following columns for each object (base table and index): object_na ...

1106 Part VIII: Performance Tuning and Optimization With T-SQL, compression may be initially set when the object is created by a ...