Great article David.

It shows how difficult it can be to come up with ways to automate what a human should be doing.

At one point we would take a hour out of the day an do first person shooters at our desks. Those that were out of office...

Great article.

I want to thank you for something else though. You put all of your scripts into a file and included it rather than leaving it to be copied...

It's a quote from a Jim Henson film called "The Dark Crystal[/url]".

In the film there was a fractured crystal (the MacGuffin). There was a...

The shard?

Trial By Stone!!!

I'm a bit late to the party but ...

Just because Microsoft does it it or does not do it is no excuse for me to do it or not do...

I like to have my main data files and log files on different physical drives. Your script will put all of the files for a database in the same...

The new guy? Typically it is the new guy who thinks that the manager is the one full of ...

Since I did not see any mention of file encoding...

The split password and side-by-side authentication reminds me of the old days under ground when we both had to turn our key at the same time. :w00t:

There is an oft quoted poem that I will re-quote here:

It is by caffeine alone I set my mind in motion,it is by the beans of Java that thoughts...

Good one Jason!

What version of SQL Server are you working with? Looks like even BOL can be wrong. Like I always say, "It could happen." 🙂

I had...

Stored procedures cache the execution plan at the time the procedure is compiled. On the other hand a query may get a new execution plan every time that it...

Thanks Gail. I had missed that point.

Toby, the O/S fragmentation does not have anything to do with the shrink. Actually it does not even apply to index fragmentation....

TheSQLGuru (4/30/2015)

That would be so nice...