Code I’d Hate To Live Without: T-SQL Tuesday #104


July 10, 2018 by Kenneth Fisher

T-SQL TuesdayIt’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his vlogs before take some time and watch a few. They are entertaining, informative and best of all short :). I’m really enjoying the work Bert! Keep on trucking!

Anyway, this time around Bert wants us to post some code that we use that we just can’t live without. That’s a bit hard for me since I’m constantly posting about code I’ve written or enjoy using. So here is my solution (<- pun there, you'll get it in a second), a while back I wrote about using solutions (see? I thought that was rather funny myself.) in SSMS to store the scripts I use on a regular basis. So I thought this time around I would go through and create a list of links to the sources for many of the most useful scripts.


  • Notes are just that. Pieces of scripts, or a series of scripts to remind me of things.
  • Query means that this is something I can open and run without much input. Frequently there are commented out parameters or variations. But in general I can just open and run.
  • SPs These are create scripts for SPs that I use on a regular basis. I keep them here because I work with hundreds of servers and I’m never sure which ones have them and which don’t. Also a lot of times the documentation is at the top of the script.

Creating the solution

Now obviously for the scripts that I’m getting from other people that are being constantly updated I pull them down and replace them every now and again. Others that I write I’ll make changes to as I think of something. I’d like to think why I have most of these is pretty self explanatory. Basically, if I have to do something twice and there might be a third time I’m going to find a script for it. If I don’t find one I’m comfortable with right then I do my best to write my own. Oh, and once I’ve used the script for a while I clean it up and blog it. (In case you hadn’t noticed.)

And last but not least, some of these (the What’s going on & Backup scripts) that I use that most often I pin to a separate tab row.

3 thoughts on “Code I’d Hate To Live Without: T-SQL Tuesday #104

  1. notarian says:

    I wonder if Eugene Meidinger uses sp_RestoreGene

  2. […] to find where your backups are. And I’ve also written about I use a solution in SSMS to hold a bunch of my scripts. I was using this again today (I use it a lot!) and thought I would bring it back up with some […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: