Viewing 15 posts - 13,861 through 13,875 (of 22,219 total)
I'm sorry, I don't understand the order that you're trying to achieve. It doesn't look like you're ordering by managerid or by employee id. Are you trying to retrieve 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
December 1, 2010 at 5:42 am
For what it's worth, foreign keys, constraints, statistics, and indexes can all affect the execution plan, so simply pointing at a query and asking which table is accessed first can'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
December 1, 2010 at 5:32 am
WayneS (11/30/2010)
To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!
Oooh, good question. I haven't. I have listed...
"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
December 1, 2010 at 5:17 am
Kit G (11/30/2010)
Grant Fritchey (11/30/2010)
Jeff Moden (11/30/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 30, 2010 at 7:42 am
This is piling on, but I agree with Gail & Lowell. I've had the situation where certain tables (badly designed tables I might add) needed stats updated hourly, with 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
November 30, 2010 at 7:40 am
It sounds like the regressions I've heard from other people. In general, SQL Server 2005 and 2008 are much better with execution plans, etc, than 2000. But, there were 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 30, 2010 at 7:35 am
Basically you install the management pack and you're off & running. But, you'll need to adjust the alert levels, etc., for your system. You'll also want to review the counters...
"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 30, 2010 at 7:33 am
Jeff Moden (11/30/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 30, 2010 at 6:48 am
deva21v (11/29/2010)
Since i can't use this dmv's for following reason1) When sql server services stop data in dmv will be cleared
Yes, but how often is that occurring? In production...
"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 30, 2010 at 6:07 am
Not only is it running on SQL Server, but you can watch the monitoring on the system, live, from here[/url]. Check out how well it operates and see Red Gate's...
"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 29, 2010 at 1:18 pm
You're going to learn different things in different places. Small companies will give you a lot more breadth of knowledge because you won't be able to specialize in any one...
"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 29, 2010 at 12:21 pm
Yeah, I haven't seen corrupt stats, so I'm curious how they evidence as well.
"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 29, 2010 at 11:16 am
Without the code and structures it's hard to know, but based on what you described, it sure sounds like all you need is a simple join to bring back 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 29, 2010 at 7:43 am
Unless there's something you're not listing here, there's no reason to go with temp tables in the query you've shown.
Just piling on to this one to reinforce the message.
"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 29, 2010 at 7:41 am
GilaMonster (11/29/2010)
Greg Edwards-268690 (11/29/2010)
Maybe they want to add some new enhancements.Nope. No new enhancements. I think that a Dec go-live interferes with vacation plans
Exactly! I regularly have to remind our...
"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 29, 2010 at 7:21 am
Viewing 15 posts - 13,861 through 13,875 (of 22,219 total)