MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide: Exam 70-442

Front Cover
John Wiley & Sons, Apr 2, 2007 - Computers - 632 pages
As your essential guide to Microsoft’s new SQL Server 2005 certification (exam 70-442), this book offers you practical and in-depth coverage. Full coverage of all exam objectives is presented in a systematic approach so you can be confident you’re getting the instruction you need for the exam. Plus, practical hands-on exercises reinforce critical skills and real-world scenarios put what you’ve learned in the context of actual job roles. Finally, challenging review questions in each chapter prepare you for exam day.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Designing Data Access
1
Designing Data Access
8
Designing Application Access
43
1 Adding a Reference to SMO Assemblies
56
Designing Queries
85
1 Using SHOWPLAN_XML to View the Query Plan
95
2 Querying Data Using FLWOR Statements
103
6 Querying XML Database Data Using the Nodes Method
110
Optimizing Indexing Strategies
365
Optimizing Indexing Strategies
368
1 Finding a Missing Index for a Query
394
Scaling Out Applications
421
1 Scaling Out AdventureWorks Using Partitioning
428
Resolving Performance Problems
451
Troubleshooting Database Design
458
Troubleshooting CPU Problems
464

8 Modifying XML Database Data Using the replace value
116
Using Cursors
133
Setting Up Monitoring Preliminary Exercise
144
DYNAMIC Cursor
153
Planning Error Handling
172
1 Defining a SQL Server Agent Alert
226
Transaction Isolation Levels
240
Planning a Transaction Strategy
242
Optimizing and Tuning Queries for Performance
305
1 Use SQL Server Profiler to Obtain the Query Showplan
327
1 Monitoring Recompilations Using SQL Server Profiler
473
Troubleshooting Memory Problems
483
2 Using the Dedicated Administrator Connection
495
Optimizing Data Storage
509
Case Studies
561
Case Studies
564
Glossary
589
Index
603
Copyright

Common terms and phrases

About the author (2007)

Marilyn Miller-White, SQL Server 2005 MCTS and MCITP, MCT, MCDBA, MCSE, is the owner of White Consulting, a New Jersey-based consultancy specializing in database and systems training and solutions.

Cristian Andrei Lefter is a SQL Server MVP, developer, database administrator, trainer, and CEO of MicroTraining, a consulting and training company.

Bibliographic information