List of Exercises

Chapter 1: Designing a Data Access Strategy

Exercise 1: Connect Using ADO.NET

Exercise 2: Connect Using SQL Native Client

Exercise 1: Create an HTTP Endpoint

Exercise 2: Consume the HTTP Endpoint

Exercise 1: Retrieve Data Using a Dataset

Exercise 2: Retrieve Data Using a DataReader

Chapter 3: Designing a Cursor and Caching Strategy

Exercise 1: Use the OutputCache Directive

Exercise 2: Evaluate the Effects of Caching

Exercise 1: Create a Cursor

Exercise 2: Compare Cursor Alternatives

Exercise 1: Create a Scrollable Cursor

Exercise 2: Examine a Cursor

Chapter 4: Advanced Query Topics

Exercise 1: Create a Database by Using an SMO Application

Exercise 2: Create a Data-Mining Structure

Exercise 1: Compare Execution of Queries With and Without MARS

Exercise 1: Use the Callback Feature

Chapter 5: Data Integrity and Error Handling in SQL Server 2005

Exercise 1: Apply a Data Validation Rule to Tables

Exercise 1: Create an Initial Stored Procedure

Exercise 2: Create an Initial Try/Catch Block

Chapter 6: Designing Transactions and Transaction Isolation

Exercise 1: Acquire Locks by Using the Read Committed Isolation Level

Exercise 2: Acquire Locks by Using the Read Committed Snapshot Isolation Level

Exercise 1: Use the Default Isolation Level

Exercise 2: Use a Locking Hint

Exercise 3: Use an Alternative Solution

Chapter 7: Optimizing SQL Server 2005 Performance

Exercise 1: Test Using a Small Result Set

Exercise 2: Test Using a Large Result Set

Exercise 3: Optimize Query #3

Exercise 1: Create a Performance Base Line for the Query

Exercise 2: Optimize the Query by Using Clustered Indexes

Exercise 3: Optimize the Query by Using Covered Non-Clustered Indexes

Exercise 4: Optimize the Query by Implementing an Indexed View

Exercise 5: Compare the Test Results

Chapter 8: Improving Database Application Performance

Exercise 1: Create a Partition Function

Exercise 2: Create a CLR User-Defined Function

Exercise 1: Use Profiler to Analyze Performance