Viewing 15 posts - 1 through 15 (of 21 total)
So, any interesting *terrible* stories behind this article? Feel free to share.... (Wanna get my Schadenfreude on...)
November 7, 2018 at 3:31 am
I will give this a try - thanks for the info!
August 12, 2018 at 8:56 am
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.
February 3, 2016 at 3:01 am
Hmm, thats a great find about db's without backups... I will modify the script and upload a new version! thx!
July 27, 2015 at 5:59 am
What do you mean reshaped? Any specific requirements?
July 15, 2015 at 6:04 am
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...
July 3, 2015 at 5:33 am
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...
July 3, 2015 at 5:15 am
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...
December 6, 2013 at 11:04 pm
I figure this is sorted... but just check that auto close is not set to ON.
November 26, 2013 at 5:46 am
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...
September 26, 2013 at 6:58 am
omg, it messed up all my nice formatting of white space!!! noooooo! *cries in corner* 😛
April 16, 2010 at 2:00 pm
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...
April 16, 2010 at 1:58 pm
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....
July 7, 2009 at 12:12 pm
Hmm, that is interesting. What is the value of the SampleDays column?
I am glad that you found some use for it... 😉
Ah, I see you are a bit ahead of...
February 12, 2009 at 6:32 am