Over time I’ve accumulated a number of useful scripts and stored procedures. To help you out, I’ve bundled them up into a kit that I make freely available; after all, why duplicate someone else’s work?
A stored procedure which allows easy disabling and rebuilding of indexes on SQL Server tables, for the purposes of increasing performance on bulk operations.
A stored procedure that makes capturing and viewing block chain information a breeze.
I don’t know about you, but I really hate clicking all those buttons in Profiler. This procedure makes setting up and reading data from traces really easy.
This makes calculating the ideal file size for SQL Server data files easy, and even gives you the commands to either grow or shrink (ugh, I hate that word) them.
Enter your e-mail address below and I’ll send you a link. I’m adding new ones and enhancing the existing ones all the time, so be sure to watch your inbox!