Eirikur, I completely agree about the month formatting. That kind of thing is definitely not preferable. It was only done to try to make the output the same in all...

Oh. Thanks, Gail. I need to look into that code discrepancy. I'm not sure what happened there. I was looking at the inline code in the article and my own...

Thanks for the response, Eirikur. You are correct that I missed the TRUNCATE with the set solution. I'll look into correcting that later today. Regarding your 3 points about statistics,...

Even though this thread started 6.5 years ago, it continues to help people. Earlier today, I started searching for answers because I couldn't shrink data files in tempdb in a...

Great thread, Grant.

For some very common tasks (who is doing what, table sizes in a database, which modules contain this text) I have some custom procedures I wrote and use...

I like option 1 because it can make both viewing and editing simpler for the users.

Yes. I definitely advise caution before using any busy system like that, and that's why we just use it as a simple tool for our development environments.

I frequently use schemas to logically group objects by functional area, department, etc. Sometimes, that is extended to implement schema-level security.

I did have one application that was quite different. I...

This is my first script published at SQL Server Central. I plan to submit more scripts and articles in the future. You can also find me (and a lot of...

We use this script for development databases and occasionally for refreshing a snapshot of a reporting database. It works great for us in those situations, but I advise caution if...

I think the only reason the 3rd query didn't return the correct results is because you forgot to include your original filter in the top-level query. I agree with Garadin's...