Flylib.com
List of Exercises
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
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
BUY ON AMAZON
Beginning Cryptography with Java
Symmetric Key Cryptography
Object Description in Cryptography Using ASN.1
SSL and TLS
Appendix A Solutions to Exercises
Appendix C Using the Bouncy Castle API for Elliptic Curve
High-Speed Signal Propagation[c] Advanced Black Magic
Impedance of Linear, Time-Invariant, Lumped-Element Circuits
Pcb Configurations
LVDS Signaling
Generic Cabling Architecture
Arithmetic of Clock Skew
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Internet Security Systems RealSecure
Cisco Secure IDS
Data Correlation
Incident Response
Security Business Issues
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoCube
Using a Variable to Access a Hierarchy Node Directly
Creating an Authorization Profile Using Profile Generator
Object Transport
Section A.1. ASAP for BW
Java All-In-One Desk Reference For Dummies
Book III - Object-Oriented Programming
Working with Statics
Using Inner Classes
Swinging into Swing
Using JDBC to Connect to a Database
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Arrays and Collections
XML
Windows Programming
ADO.NET
Useful COM Interop
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies