- Optimize and tune queries for performance
Creating Partitioned Views
Table Hints (Transact-SQL)
SET ANSI_PADDING (Transact-SQL)
Introducing SQL Trace
max degree of parallelism Option - Optimize indexing strategies
XML Best Practices
Planning Guidelines for Partioned Tables and Indexes
Creating Partitioned Tables and Indexes - Scale database applications
Creating Distributed Partitioned Views - Resolve performance problems
Dynamic Management Views and Functions (Transact-SQL)
Performance Optimizations for the XML Data Type in SQL Server 2005
sys.dm_os_wait_stats (Transact-SQL) - Optimize data storage
Data Normalization
Monday, February 23, 2009
Exam 70-442 Objective 5
Tested myself on Exam 70-442 (Designing and Optimizing Data Access by Using Microsoft SQL Server 2005) Objective 5 (Performance Tuning a Database and a Database Application) and received only 32%. I've got a bit of study to do, specifically:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment