New Transact SQL Video Tutorial: SET Commands for Performance Tuning and Query Execution Statistics

SET Commands for Performance Tuning and Query Execution Statistics - view details

This is a rather length video (over 21 minutes) due to the in-depth explanations and demos of each of the SET options available for performance tuning and optimizing queries. This video is valid for both SQL Server 2005 and SQL Server 2000 with highlights on the new features available in SQL Server 2005.

Highlights from this video:

• SQL Server 2005 and SQL Server 2000 SET Commands for optimization and tuning
• Difference between STATISTICS and SHOWPLAN
• SET STATISTICS IO and SET STATISTICS TIME
• The new SET STATISTICS XML
• SET SHOWPLAN choices (SHOWPLAN_ALL, SHOWPLAN_TEXT)
• SET STATISTICS PROFILE
• Detailed explanations of stats output
• Comparisons between graphical show plan and text showplan

---

• Source: http://www.LearnTransactSQL.com
• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 300 (Intermediate)
• Length: 21:16 (17.5MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: node, graphical plan, SET STATISTICS IO ON, SET STATISTICS IO OFF