Some queries run best on one CPU. In this sixty second video I show how to restrict such a query to a single processor with OPTION (MAXDOP 1).
SQL SERVER – Table Variables and Transactions – SQL in Sixty Seconds #007 – Video
Many developers expect a rollback to undo changes in a table variable. This sixty second video on table variables and transactions shows it does not.
SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video
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 – 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.