Viewing 15 posts - 4,261 through 4,275 (of 18,926 total)
SQLRNNR (7/28/2011)
Ninja's_RGR'us (7/28/2011)
SQLRNNR (7/28/2011)
I like the script. I think it would be a good idea to note on your blog how you created that script.;-)
Sure it might help us...
July 28, 2011 at 11:02 am
clarification (7/28/2011)
got u but hostname as dot means?
I don't know, never had that happen to me and my network admin is out at the moment. If I had to...
July 28, 2011 at 11:01 am
SQLRNNR (7/28/2011)
I like the script. I think it would be a good idea to note on your blog how you created that script.;-)
Sure it might help us build a...
July 28, 2011 at 10:59 am
SQLRNNR (7/28/2011)
Ninja's_RGR'us (7/28/2011)
Yup, thank the author (top comment).Don't want to take the credit when it's not mine ;-),
Well, I'll have to thank Microsoft sometime for that script. I decided...
July 28, 2011 at 10:58 am
Happy to help. It really works much better than MP. Just a little harder to setup at first but it pays off multitudes on the long run.
July 28, 2011 at 10:57 am
Not sure of what the question is. What was the wait reason? That is actually your answer.
IE you can be blocking yourself if you are rebuilding a big...
July 28, 2011 at 10:54 am
You seem to have a 3rd party app take takes all your backups. It's been failing for days.
Please run this and post back what it returns :
DBCC CHECKDB('model')...
July 28, 2011 at 10:52 am
Discussion continued here : http://www.sqlservercentral.com/Forums/Topic1150380-5-1.aspx
July 28, 2011 at 10:37 am
Run DBCC updateusage() first. Then both should be correct.
2K5 gives you much better tools to report on this if that can help you make the move!
P.S. You can edit...
July 28, 2011 at 10:36 am
I've seen 3rd party apps do crazy things but that would take the cake.
Can you post the logs content plz?
July 28, 2011 at 10:34 am
PeterG-377490 (7/28/2011)
thanks Steve.......didn't mean to call you CRAZY!!!! Picked up the wrong name.
Not the first time it happens! Don't sweat it 😉
July 28, 2011 at 10:33 am
With that distribution I'd really go with PK : SKU, endt
Then clustered on the date.
Your PK will be way more selective that way.
July 28, 2011 at 10:32 am
Jack Corbett (7/28/2011)
mtillman-921105 (7/28/2011)
cengland0 (7/28/2011)
July 28, 2011 at 10:08 am
malachyrafferty (7/28/2011)
cheers ninja - we actually are running pretty decently - i was just wondering if there was anything that maybe would give us an unexpected boast in sp3
Sure give...
July 28, 2011 at 10:07 am
Viewing 15 posts - 4,261 through 4,275 (of 18,926 total)