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




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

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