Chapter 18. Debugging and Profiling

for RuBoard

The program may not be broken, but it does hurt.

Martin Fowler ^[1]

^[1] Fowler, Martin. Refactoring: Improving the Design of Existing Code . Reading, MA; Addison-Wesley, 1999. Page 7.

In this chapter we'll talk about debugging and profiling Transact-SQL stored procedures. We'll also talk about how to stress test SQL Server using Transact-SQL queries and a free stress testing tool that you'll find on the book's CD.

for RuBoard