Resource Governor workload groups let you limit CPU and memory for competing workloads. This introduction answers what Resource Governor is and why you need it, then shows a full T-SQL setup example.
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.
Changing an Index In Place With CREATE INDEX and DROP_EXISTING
Use DROP_EXISTING to change an index definition in one operation, inspect its columns, and check online availability and dependencies.
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.
Columnstore Indexes for Reporting Tables
Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.
SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE
Learn to write a hierarchical query using a recursive CTE with a short video and a quiz on an employee and manager table. Check your answer.