Viewing 15 posts - 13,906 through 13,920 (of 22,219 total)
Craig Farrell (11/22/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 6:46 pm
Ah, well, you might be in trouble then. 1/3 to 1/2 of the table being deleted is likely to lead to table locks.
You might want to look at partitiioned...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 1:35 pm
3 million rows out of how many?
And again, an index alone won't necessarily do much for you, and could hurt you. What's the clustered index?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 1:26 pm
A lot of it also depends on your indexing architecture. Are you deleting based on the clustered index and, will those deletes take place in a different part of the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 12:44 pm
That script isn't set up to run on 2000. You'll have to gather the metrics other ways.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 11:02 am
Chris Morris-439714 (11/22/2010)
CirquedeSQLeil (11/22/2010)
Chris Morris-439714 (11/22/2010)
Wishing Jack C a speedy recovery and some quality time for recuperation.Get well soon, mate.
Did I miss something more than the burnout?
Our DBA caught some...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 10:03 am
Not a problem. If you run into specific issues, please come back around and post them here. People are very excited to help out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 7:44 am
Check the backups. First thing. Validate that they're running, running correctly, are scheduled, etc. Then, identify the most important databases and validate that you can run a restore of the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 22, 2010 at 7:35 am
GilaMonster (11/19/2010)
Grant Fritchey (11/19/2010)
GilaMonster (11/19/2010)
Irreparably suspect, no backups.http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx
Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.
That's it. We're cancelling Christmas for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 11:03 am
WayneS (11/19/2010)
Grant Fritchey (11/19/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 10:26 am
GilaMonster (11/19/2010)
Irreparably suspect, no backups.http://www.sqlservercentral.com/Forums/Topic1023390-146-1.aspx
Doesn't say much for my mood that I slightly enjoyed posting that last message there. Wrong, I know.
That's it. We're cancelling Christmas for you two.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 9:29 am
GilaMonster (11/19/2010)
Brandie Tarvin (11/19/2010)
And here's a big ol' U.S. standard baseball bat.Jo. Bokken. Katana. Baseball bat.
Decisions, decisions....
Clue-by-four.
Question is, do you want to hurt 'em or just cut 'em up?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 6:24 am
GilaMonster (11/19/2010)
Conversation from 5 min ago.
PM: We agreed that you'd start the investigation for <really complex and possibly impossible data extrapolation> on Monday. Is there any...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 6:10 am
ubeauty (11/19/2010)
Whilst on the train though i personally class this as work time...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 4:53 am
Interesting topic...
While I absolutely agree that work/life balance is thrown off by these devices, the fact is, the devices are out there. It's not a question of whether or not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 19, 2010 at 4:52 am
Viewing 15 posts - 13,906 through 13,920 (of 22,219 total)