So, any interesting *terrible* stories behind this article? Feel free to share.... (Wanna get my Schadenfreude on...)

Hi Jacob,

I will give this a try - thanks for the info!

Regards,
Nicholas W.

Leaning away from the direction this thread has gone, I just want to say that I use mount points on some of the clusters I have running at a client.

/Rant

...However,...

Hmm, thats a great find about db's without backups... I will modify the script and upload a new version! thx!

What do you mean reshaped? Any specific requirements?

Hi Gregg,

hmm, that is rather awkward - 7 hours? That does seem rather long...

Remember that the ghost cleanup is a single threaded process and it can actually be in a...

The challenge I have had with differential backups with some OLTP systems I have worked on is that the rate of data change is higher than the overall size of...

Hi Guys

This is very weird...

I believe I wrote this about 4/5 years ago and submitted it back then to SQLServerCentral... I have no idea why it is popping up now...

I figure this is sorted... but just check that auto close is not set to ON.

Greetings all.

Apologies for awaking a sleeping dog...

There may be a faster way around your challenge than adding the result set definition to all the procs.

Though it is not without it's...

omg, it messed up all my nice formatting of white space!!! noooooo! *cries in corner* 😛

Perry's way will work if you set it up correctly. using the maintenance plan clean up task will also work. (generally what I use as its pretty easy.)

But just for...

huh, that is a little strange. How are you performing the stats update?

I would probably just ensure that the database options 'auto update stats' and 'auto create stats' are enabled....

huh, that is a little strange. How are you performing the stats update?

I would probably just ensure that the database options 'auto update stats' and 'auto create stats' are enabled....

Hmm, that is interesting. What is the value of the SampleDays column?

I am glad that you found some use for it... 😉

edit:

Ah, I see you are a bit ahead of...