Viewing 15 posts - 4,606 through 4,620 (of 18,926 total)
Ignacio A. Salom Rangel (7/21/2011)
Ninja's_RGR'us (7/21/2011)
Ignacio A. Salom Rangel (7/21/2011)
Try to do it all over again and see if it works this time, something may have happened since yesterday.
No I...
July 21, 2011 at 8:09 am
yes either switch to simple recovery or take log bakcups. There's no 3rd option.
here's how to shrink the logs. Please notice that I switch back to full and...
July 21, 2011 at 8:05 am
I can keep toying with it if you want but I need the rdl and sample data. This back and forth is getting old.
July 21, 2011 at 7:59 am
And to fix defragmentation : http://sqlfool.com/2010/04/index-defrag-script-v4-0/
July 21, 2011 at 7:57 am
Ignacio A. Salom Rangel (7/21/2011)
Try to do it all over again and see if it works this time, something may have happened since yesterday.
No I said to not try things...
July 21, 2011 at 7:54 am
Same to you.
Edit, where the darn taxic nuclear waste icon???
July 21, 2011 at 7:35 am
BinaryDigit (7/21/2011)
Is there something I can put into query to make it never cache?
OPTION (RECOMPILE) for statement level
WITH RECOMPILE at the proc creation level to not save the plan.
July 21, 2011 at 7:34 am
SanDroid (7/21/2011)
Ninja's_RGR'us (7/21/2011)
Thanks SanDroid but my question also included a test on Sql 2K5 ;-).My answer did not. And nither did the QOTD. 😛
I know, MY question did :-D.
July 21, 2011 at 7:15 am
bopeavy (7/21/2011)
Ninja's_RGR'us (7/21/2011)
Please read my full explaination in my first post of the thread.
You must have a keyboard shortcut for this by now.;-)
Yup it's called ctrl-c...
July 21, 2011 at 7:12 am
Brandie Tarvin (7/21/2011)
Or do you just keep in...
July 21, 2011 at 7:11 am
Thanks SanDroid but my question also included a test on Sql 2K5 ;-).
July 21, 2011 at 7:10 am
BinaryDigit (7/20/2011)
I know that stored procs are a lot better than executing the same script all the time because it is able to cache, but becasue caching will mainly help...
July 21, 2011 at 6:53 am
Bottom live fore me is that this is a nive reminder of that function. I frankly don't care wether I get NULL vs 1900-01-01 when running it. :w00t:
July 21, 2011 at 6:50 am
cengland0 (7/21/2011)
Thomas Abraham (7/21/2011)
Yes, I did change the mode.Edited later: BUT, I didn't cycle the serve after the mode change. Does that make a difference?
So to be sure, you had...
July 21, 2011 at 6:37 am
Viewing 15 posts - 4,606 through 4,620 (of 18,926 total)