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

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
Detailed Outline

Course Schedule