Indexes are the first baby step in tuning SQL Server performance. This SQL in Sixty Seconds video, #006, covers indexing basics in about a minute.
SQL Server – Learning SQL Server Performance: Indexing Basics – Video
Indexes are the first step in any performance tuning exercise. Our new video course on indexing basics covers creating, analyzing and maintaining indexes.
SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video
Many asked for a demo after our video on errors and reactions. In SQL in Sixty Seconds #005, Rick Morelan shows how SQL Server reacts to a T-SQL error.
SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video
SQL in Sixty Seconds #004 for February 29th: a short function that checks if any year is a leap year, using the SQL Server 2012 IIF, EOMONTH and CONCAT functions.
SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video
In SQL in Sixty Seconds #003, Vinod Kumar shows T-SQL constructs for declaration and initialization of variables, a simple trick to save time.
SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video
In SQL in Sixty Seconds #002, Rick Morelan explains T-SQL errors and reactions: what SQL Server does when it hits an error, in about a minute.
SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video
The first SQL in Sixty Seconds video shows how to convert subquery to CTE in about a minute. Short, easy tips from my co-authors and me.