Viewing 15 posts - 18,346 through 18,360 (of 22,219 total)
Or you could spend a trivial amount of cash & pick up Red Gate's SQL Compare. It's a fantastic tool.
"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
February 18, 2009 at 7:12 am
Don't use a cursor. They're notoriously slow.
For more specific answers, I'd need to see the query & structure.
"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
February 18, 2009 at 7:07 am
I'm not entirely sure I understand the problem. From the sounds of it, you think the compile doesn't affect CPU. It does.
If you can, can you post the query, an...
"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
February 18, 2009 at 7:06 am
I'd be focused pretty much on the hardware and configuration issues. I remember the time we were troubleshooting a production performance problem. I backed up the database, moved it to...
"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
February 18, 2009 at 7:03 am
I think if you go over to Red Gate you can still get a copy of my book on execution plans for free. You'll have to poke around. I don't...
"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
February 18, 2009 at 6:57 am
Ramesh (2/18/2009)
"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
February 18, 2009 at 6:53 am
If you can pay for it, Solid Quality [/url]offers several good courses that will move you ahead.
"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
February 18, 2009 at 6:51 am
Ours is tied to company performance. They make a series of predictions at the beginning of the year. Depending on how well we do versus the predictions, we get a...
"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
February 18, 2009 at 6:49 am
GilaMonster (2/17/2009)
colin Leversuch-Roberts (2/17/2009)
whether you can pass one index hint i have no idea - never tried that.
You can't. Plan guides are limited to the hints that appear...
"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
February 18, 2009 at 5:42 am
Addresses are a pain in the tucas, and yeah, complex storage can be confusing, but I've just found that the more complex storage mechanisms provide a level of versatility on...
"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
February 18, 2009 at 5:41 am
Jeff Moden (2/17/2009)
"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
February 18, 2009 at 5:33 am
Jeff Moden (2/17/2009)
Lynn Pettis (2/17/2009)
GilaMonster (2/17/2009)
<Sigh> Why don't people read the manuals?Thinking and Reading that would mean. On silver plater answer should be.
Heh... "STAR"... Start Thinking And Reading. ...
"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
February 18, 2009 at 5:32 am
Bruce W Cassidy (2/17/2009)
"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
February 18, 2009 at 5:30 am
GSquared (2/17/2009)
"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
February 18, 2009 at 5:21 am
Getting the statistics update away from the index rebuilds is great, but dropping the statistics maintenance entirely might not be the best idea. You should monitor your queries to see...
"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
February 17, 2009 at 4:52 am
Viewing 15 posts - 18,346 through 18,360 (of 22,219 total)