Performance impact: stored procedures, SQL batches, and CPU usage

(Linchi Shea) What is the simplest way to drive a CPU to 100% using T-SQL? If it’s a language like C++ or C#, the simplest way is to create a tight loop and perform some work that uses CPU cycles inside the loop. For instance, the following tight loop in C# can peg a CPU to 100%:

Read More - Register for Free Membership