Viewing 15 posts - 736 through 750 (of 18,926 total)
If you're deleting that much data (assuming Chris' Dates are ok), you might be better off just rebuilding the table and only import what you want to keep in there.
November 29, 2011 at 4:56 am
Dev (11/29/2011)
gelimontana143 (11/29/2011)
SPAM!
Sure is, but now you're just giving him more of what he came here for!
Better now to quote him, other than his nickname.
November 29, 2011 at 4:53 am
Koen Verbeeck (11/28/2011)
(and I was looking frantically for 5 minutes to find the "catch". :-D)
Glad to see I had so much effects on you all :hehe:.
November 29, 2011 at 1:55 am
Revenant (11/28/2011)
Revenant (11/28/2011)
Jim Murphy (11/28/2011)
jcrawf02 (11/28/2011)
Awesome! Didn't you get the memo, SQL 2012 will be implemented entirely in HTML5 and AJAX?HA! Missed that on the spec sheet.
Dowload the RTM...
November 29, 2011 at 1:52 am
Never had fragmentation issues with this => http://sqlfool.com/2011/06/index-defrag-script-v4-1
November 28, 2011 at 5:34 pm
This is insignificant with that little data.
November 28, 2011 at 5:26 pm
Rambler (11/25/2011)
The problem came back (different DB's trans. log this time).
As for the questions, no there are no other I/O related errors on the SQL server or...
November 25, 2011 at 7:20 am
Lynn Pettis (11/25/2011)
November 25, 2011 at 7:18 am
I need the good and bad execution plans (actual, not estimated).
November 24, 2011 at 11:41 pm
GilaMonster (11/24/2011)
Ninja's_RGR'us (11/24/2011)
GS now works for RG so he's borderline on that one ;-).
I think you mean GF (Grant Fritchey), because last time I checked I didn't work for...
November 24, 2011 at 9:39 am
Dev (11/24/2011)
@Gail: Are you really a volunteer here in SSC? It’s hard to find such passion / dedication in volunteers. Hats Off to you!!!
The only paid memeber here...
November 24, 2011 at 9:35 am
GilaMonster (11/24/2011)
November 24, 2011 at 9:21 am
IIRC 0 stops, 2 deletes the trace definition.
Takes both commands to completely eliminate the trace from the system.
Why don't you find the person who started it and ask him to...
November 24, 2011 at 9:19 am
This solves all your problems.
http://sqlfool.com/2011/06/index-defrag-script-v4-1
You can run the dvm, you just need to be calling it from a db in 90 mode (this wors even if the other db is...
November 24, 2011 at 9:06 am
From the master himself : http://sqlskills.com/BLOGS/PAUL/post/Sample-corrupt-databases-to-play-with.aspx
November 24, 2011 at 8:24 am
Viewing 15 posts - 736 through 750 (of 18,926 total)