Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.
SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement
Readers sent more than 50 answers to my swap puzzle. Here are 5 different ones that swap a column value without CASE statement, plus my own three.
SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage
Jeff said my Resource Governor script did not limit CPU at all. After a few emails we found why, and how CAP_CPU_PERCENT really limits CPU usage.
SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video
SELECT * pulls extra columns, hurts plans and makes debugging hard. This sixty second video shows two tricks to replace SELECT * with column names.
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 SEQUENCE in SQL Server 2012 – Guess the Next Value
A fun puzzle on SEQUENCE in SQL Server 2012: a sequence starts at 3 and cycles with a maximum of 5. Can you guess the next value it returns?