Use SQL Server documentation with the right version and platform selected, read syntax carefully, and keep useful reference material offline.
Building a Reference You Will Actually Use Again
Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.
SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan
Performance tuning is a long journey, and the Execution Plan is its map. A video on how to begin tuning queries with SQL Server execution plans.
An Error Handling Template for Stored Procedures With THROW
Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
SQL SERVER – Simple Example to Configure Resource Governor – Introduction to Resource Governor
What is Resource Governor and why use it? It limits CPU and memory for competing workloads. A simple question and answer introduction with an example to set it up.
SQL SERVER – Fix: Error 147 An aggregate may not appear in the WHERE clause
Error 147: An aggregate may not appear in the WHERE clause. A beginner was stuck on it for a long time, so here is the simple fix, explained for beginners.
SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117
NULL is fun to ask about in interviews, since every answer I get is different. A short puzzle on NULL that raises Error 8117, and how to fix it.