Tag: stored procedures

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 5 min read

Recompile All SQL Server Stored Procedures with this Script

Recompile all stored procedures in a SQL Server database with a single script. Refresh stale execution plans after schema or statistics changes without dropping any objects.

Read article →
15 May 2018 · 5 min read

How to Search every Table in a SQL Database for a String

Learn how to build a stored procedure that searches every table and character-based column in a SQL Server database for a specific string value.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.