Viewing 15 posts - 13,906 through 13,920 (of 22,224 total)
DavidL (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 23, 2010 at 4:17 am
Paul White NZ (11/23/2010)
GilaMonster (11/23/2010)
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of...
"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 23, 2010 at 4:15 am
Some other potential optimizations. You have a whole bunch of DISTINCT operations. These are aggregates and when you see them everywhere in a query it's usually indicative of poor programming...
"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 23, 2010 at 4:13 am
pavan_srirangam (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:53 pm
Jeff Moden (11/22/2010)
I just don't ever want to be that "productive". Down-time is very important to me.
What is this "down-time" of which you speak?
"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:51 pm
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
Viewing 15 posts - 13,906 through 13,920 (of 22,224 total)