Home >
SQL Server >
SQL Server: Advanced Transact-SQL Tuning via Execution Plans
SQL Server: Advanced Transact-SQL Tuning via Execution Plans
| Course Code: |
SQSATS |
| Currency: |
SQL Server 2005, 2008, 2008 R2 |
| Duration: |
4 days |
| Audience: |
Experienced T-SQL developers, DBAs and administrators |
| Prerequisites: |
Completion of our course
SQL Server: Microsoft Transact-SQL for Beginners or equivalent knowledge. |
| Summary: |
This presentation details T-SQL tuning and best practices. To
these ends, its mainly hands-on approach uses SQL Server's
Execution Plan and Database Engine Tuning Advisor (DTA) to
optimize index and query selection, including features such as:
- Join optimisation
- Grouping sets
- Correlated vs. non-correlated subqueries
- Common Table Expressions (CTEs)
- Indexed views
- Index design and usage
- Isolation levels
- Locking and concurrency
- Elapsed, CPU and I/O times
|
| Objectives: |
Upon completion of this course, the participant should be able to
use SQL Server's Execution Plan and DTA to assist in making
efficient T-SQL and index choices for both OLTP and data
warehousing environments.
|
| Lab: |
About 65% hands-on, using Execution Plan facilities |
Detailed Outline |
|