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 – A Puzzle – Swap Value of Column Without Case Statement
An interview puzzle: write one UPDATE that flips male to female and female to male. Can you swap value of column data without a CASE statement?
A Repeatable Workload: Testing a Tuning Change Fairly
One quick run can fool you. Here is a small, fixed test you can rerun before and after any index.
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 – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier
Error 10920 stops you from dropping a user-defined function that is still the Resource Governor classifier. Here is why, and how to clean it up.
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.