Read a technical book with a practical question, small SQL experiments, and reusable notes that turn each useful chapter into working knowledge.
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.
A Separate Clustered Index for a Nonclustered GUID Primary Key
The primary key and the clustered index are two different jobs. This demo keeps the GUID as the public ID and clusters on an identity column instead.
What Is a View in SQL Server?
A view in SQL Server is a saved query, not a saved copy. Nothing is stored, the text is run every time, and that single fact explains what a view is good for and why it never makes anything faster.
Cleaning Up Ownership Before Dropping a Departed User
DROP USER fails when the user still owns a schema, a role or a table. Here is how to find those owners and hand them over safely.