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?
sp_EnableDisableIndexes
A stored procedure which allows easy disabling and rebuilding of indexes on SQL Server tables, for the purposes of increasing performance on bulk operations.
sp_get_block_chain
A stored procedure that makes capturing and viewing block chain information a breeze.
sp_trace_helper
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.
sp_balance_data_file
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!
[optinform]