The Art Of The SQL Server Stored Procedure: Wrap Up And Final Thoughts

Thanks For Reading!

Here’s the full list of posts from the series:

• The Art Of The SQL Server Stored Procedure: What You Need To Know
• The Art Of The SQL Server Stored Procedure: ANSI/SET Options
• The Art Of The SQL Server Stored Procedure: How To Leave Good Comments
• The Art Of The SQL Server Stored Procedure: Formatting Code
• The Art Of The SQL Server Stored Procedure: Error Handling
• The Art Of The SQL Server Stored Procedure: Debugging
• The Art Of The SQL Server Stored Procedure: Batching Modifications
• The Art Of The SQL Server Stored Procedure: Transactions
• The Art Of The SQL Server Stored Procedure: Locking Hints
• The Art Of The SQL Server Stored Procedure: Isolation Levels
• The Art Of The SQL Server Stored Procedure: Data Types
• The Art Of The SQL Server Stored Procedure: Conditional Logic
• The Art Of The SQL Server Stored Procedure: Local Variables
• The Art Of The SQL Server Stored Procedure: Wrapper Stored Procedures
• The Art Of The SQL Server Stored Procedure: Dynamic SQL
• The Art Of The SQL Server Stored Procedure: Temporary Objects
• The Art Of The SQL Server Stored Procedure: Parameter Sniffing
• The Art Of The SQL Server Stored Procedure: Dynamic Searches
• The Art Of The SQL Server Stored Procedure: Pagination
• The Art Of The SQL Server Stored Procedure: Cursors And Loops

I will eventually revisit these to record some material on them, and perhaps expand on it.

But this is good enough for now.

Follow On

By far, the most commented on post in the series is the one about formatting. It’s mostly people continuing to be wrong about it, but it was interesting to note.

The general idea of the series was to teach developers about the types of things I always seem to be fixing and adjusting, so that I can hopefully fix really interesting problems in the future.

Of course, that all depends on folks finding these and reading them. If that were the general sway of the world, I’d probably never had been in business in the first place.

So if you’re here and reading this, you’re special.

Thanks for reading!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.