Viewing 15 posts - 16,711 through 16,725 (of 22,219 total)
Kit G (8/18/2009)
Jeff Moden (8/17/2009)[/b]
I guess that's part of what I mean... why wouldn't you correct the original blog?
I can think of one other reason not to edit the original...
"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
August 18, 2009 at 2:17 pm
While I realize that good carpenters don't blame their tools & all that... but when a carpenter is being told he has to drive nails with a coping saw... can...
"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
August 18, 2009 at 12:15 pm
Jeff Moden (8/17/2009)
Grant Fritchey (8/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
August 18, 2009 at 12:08 pm
SCOTT!
That's a really hard problem, as I'm sure you're aware. I don't have a good answer. You should start a new thread. You might also consider posting that question 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
August 17, 2009 at 7:59 pm
2005/2008 refers to it as a key lookup, but it's the same thing as a bookmark lookup. You can read about it in the books online. It has to do...
"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
August 17, 2009 at 1:01 pm
At my current company we've tried one offshore outsourcing of a single development project because it would "save money" not to mention deliver the project faster, and it would work...
"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
August 17, 2009 at 12:42 pm
Jeff Moden (8/17/2009)
GilaMonster (8/17/2009)
Jeff Moden (8/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
August 17, 2009 at 12:19 pm
jp (8/17/2009)
I dont agree with most of the points listed here.. :w00t:
Which, the original 20 or the comments that followed?
"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
August 17, 2009 at 6:20 am
Jeff Moden (8/15/2009)
GilaMonster (8/15/2009)
Jeff Moden (8/15/2009)
Yeah... I love people's blogs... 😛Ok, now I'm worried....
Heh... please don't be. Your blogs are the epitome of what every DBA and database consultant...
"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
August 17, 2009 at 5:18 am
When it's really down to the wire, I usually rely on the numbers from Profiler. I honestly don't know if that's right or not, but it's a leap of faith...
"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
August 15, 2009 at 9:08 am
You do what I do, use the same number all the time. When I'm troubelshooting from a point of view, say SSMS, I do all the measures there. If you...
"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
August 14, 2009 at 3:31 pm
I'm pretty sure this one goes way back and may not be related to the table variables. I've run into it before. Do you think this is the issue?
"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
August 14, 2009 at 10:59 am
And the Books Online can be accessed... wait for it.... online:
http://msdn.microsoft.com/en-us/library/ms130214.aspx
"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
August 14, 2009 at 10:56 am
I agree with Matt. Need is a big word. I'd say they should be and are probably also the primary key & clustered.
"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
August 14, 2009 at 10:49 am
Are those user defined functions multi-statement UDF's by any chance? I'd say that's where your problem is. Multi-statement UDF's don't have statistics. When you join them against data like this,...
"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
August 14, 2009 at 9:03 am
Viewing 15 posts - 16,711 through 16,725 (of 22,219 total)