Fantastically simple!

As for how to get the duration in YMD, here's what I came up with. I tried to code it the way I would process it in my head...

Thanks for the follow-up. Having analysts drop temp tables at the end of their stored procedures did seem to help, but I would still see sporadic out of control growth....

Of course - makes total sense! Thanks for the tip.

This seems like it would be really great, but I don't understand the results. I am having frequent problems with TempDB growing out of control, consuming an entire 200GB drive,...

Seems to me that many have missed the point of "easy to work with" and assume it means someone who rolls over and eschews taking on problems up front. I...

Great article. My advice to anyone approaching anything on a computer - whether it's software development, database administration, surfing the web, or just using office productivity applications - is to...

I really like it. With a little tweaking, I'm sure it could be coded to detect an existing filegroup on any of the indexes and insert them automatically in the...