Summary

In this chapter you learned how to debug, profile, and test Transact-SQL stored procedure code. SQL Server has several nice tools for debugging, profiling, and stress testing end-user code. And as STRESS.CMD demonstrates, it isn't hard to come up with your own when what comes in the box doesn't quite meet your needs.

Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.