After three months of SQL in Sixty Seconds, Rick Morelan, Vinod Kumar and I want your help. Pick your favorite episode so we can improve.
SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video
Need sample data to try new SQL Server features safely? This SQL in Sixty Seconds video shows how to install the AdventureWorks sample database.
SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video
Cleaning up SQL Server indexes starts with fragmentation. Learn the two types, when to reorganize or rebuild, and how fillfactor fits in.
SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video
Vinod Kumar is back with T-SQL constructs in SQL in Sixty Seconds #009, showing how .NET developers can use familiar syntax like *= and += in T-SQL.
SQL SERVER – Using MAXDOP 1 for Single Processor Query – SQL in Sixty Seconds #008 – Video
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.