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
Distinguished Names and Certificates
CMS and S/MIME
SSL and TLS
Appendix C Using the Bouncy Castle API for Elliptic Curve
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Erasing the Phone Configuration
Cisco IPC Express Automated Attendant Options
Subscriber Features
Summary
Configuring and Monitoring Via Network Management Systems Using the Cisco CME AXL/SOAP Interface
Information Dashboard Design: The Effective Visual Communication of Data
Exceeding the Boundaries of a Single Screen
Encoding Quantitative Data Inaccurately
Designing an Unattractive Visual Display
Key Goals in the Visual Design Process
Design for Use as a Launch Pad
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hacks 4051: Introduction
Hack 46. Proxy Web Traffic over SSH
Hacks 6382: Introduction
Hack 83. Make a Deep Dish Cylindrical Parabolic Reflector
Hack 90. Build a Slotted Waveguide Antenna
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Using the System.Management Namespace
Querying WMI
WMI Providers
WMI Security
FileMaker 8 Functions and Scripts Desk Reference
Date Functions
Repeating Functions
Last()
Position()
General Resources for Tips and Tricks
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