SQL Server: Advanced T-SQL Tuning via Execution Plan (Showplan)

Course Code: SQSATS
Duration: 3 days
Audience: Experienced T-SQL developers, DBAs and administrators
Prerequisites: At least one year of T-SQL experience
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 (Showplan) facilities
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page