This video is from our "SQL Server Programming (SQL Server 2005/2000): Transact SQL" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Video: SET Commands for Performance Tuning and Query Execution Statistics

Skill level: 300 (Intermediate)
Run Time: 21:16
Instructor: Scott Whigham

Description:

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

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Instructor
Related Videos
Related Courses
Other Videos in this Chapter

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Video titleSkill

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys	200	Download
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs	300	Download
Creating Database Diagrams in SQL Server Management Studio	200	Download
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause	300	Download
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)	200	Download

CourseRun TimeSkill Level

148 - SQL Server 2000 Database Administration	200-500	20+ hrs
152 - SQL Server 2005 Database Administration	200-500	30+ hrs
157 - SQL Server 2008/R2 Database Administration	200-500	46+ hrs
154 - SQL Server 2005 Reporting Services	200-500	17+ hrs
153 - SQL Server 2005 Integration Services	200-500	31+ hrs

Chapter 7: Datatypes, Conversion, Variables, Functions, Views and more

1	TOP Operator: What's New and Why Life Is much Easier Today
2	Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary
3	Variables - Understanding the Difference Between Using SET and SELECT to Assign Values
4	Variables and Scoping - Local Variables and Batch Terminators
5	DATETIME and SMALLDATETIME - Working with Dates and Times SQL Server
6	What is Context_Info?
7	Part 1 - Introduction to Using Control-of-Flow Language in Your SQL
8	Part 2 - Using IF Statements to Control Execution in Scripts and Stored Procedures
9	Part 3 - GOTO Statements and When and How to Use Them
10	Part 4 - Using EXISTS to Control Execution In an IF Statement
11	Part 5 - WHILE Loops and Implementing Looping Structure in SQL
12	Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them
13	Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions
	SET Commands for Performance Tuning and Query Execution Statistics
15	SET Commands for Working with NULL values
16	SET Commands Often Used to Control Dates and Date Formats in Input or Export Data
17	Using SET Commands Inside Stored Procedures and When Executing Stored Procedures

NOTE: This video is part of our SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter 7: Datatypes, Conversion, Variables, Functions, Views and more

Jump to a specific chapter:

Login

Video: SET Commands for Performance Tuning and Query Execution Statistics

Description:

Scott Whigham