I'm going to take advantage of this lazy Saturday afternoon to post some of my boilerplate code - this is code that I find use for on a repeat basis. Whenever I post code that you're likely to want to save and re-use, I'll tag it as boilerplate code.
Some examples:
- find all the heaps in a database
- search job code for a snippet of text
- search proc/function code for a snippet of text
- kill all of the open connections in a database (or all of the open connections from a given user)
- find all of the table and index sizes in a database
Coming up: find all of the table and index sizes in a database!
No comments:
Post a Comment