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

Course Schedule