Viewing 15 posts - 10,366 through 10,380 (of 22,232 total)
I really enjoyed that trip, although I came home utterly exhausted at the end of it. Worst thing was trying to remember what I had said or not said during...
"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
October 16, 2012 at 4:25 am
ScottPletcher (10/11/2012)
Grant Fritchey (10/11/2012)
ScottPletcher (10/11/2012)
Grant Fritchey (10/11/2012)
As an aside, the CHAR(2) would be a really poor choice for the first column in a compound key. You'd want to use either...
"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
October 11, 2012 at 12:34 pm
ScottPletcher (10/11/2012)
Grant Fritchey (10/11/2012)
As an aside, the CHAR(2) would be a really poor choice for the first column in a compound key. You'd want to use either the INT or...
"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
October 11, 2012 at 12:07 pm
I'd be nervous about creating that many indexes, especially if you're only saving a few pages read from memory. If the query was called thousands of times a minute, heck...
"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
October 11, 2012 at 6:01 am
First things first, estimated costs are not measures that you can compare between queries. They are too subject to odd variability, so don't look at cost estimates within execution plans...
"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
October 11, 2012 at 5:08 am
PiMané (10/11/2012)
I've already discussed this point but if you can enlighten me a little more I'd be grateful đŸ™‚
Suppose I have an index I1...
"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
October 11, 2012 at 4:09 am
PiMané (10/11/2012)
ScottPletcher (10/10/2012)
A three-column is not slower to do lookup on if that's what you (almost) always specify...
"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
October 11, 2012 at 4:03 am
PiMané (10/10/2012)
Grant Fritchey (10/10/2012)
"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
October 11, 2012 at 3:57 am
PiMané (10/10/2012)
I was reading about PK and Clustered Indexes over at sqlskill.com and after reading too much I guess I burned a fuse...
So pardon if this is a stupid question...
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
October 10, 2012 at 11:31 am
Jeff Moden (10/6/2012)
Someone on this thread asked what I looked for on resumes and my answer was that I basically interview anyone that...
"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
October 6, 2012 at 7:07 pm
Jeff Moden (10/5/2012)
Evil Kraig F (10/5/2012)
Nadrek (10/5/2012)
CptCrusty1 (10/5/2012)
"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
October 6, 2012 at 8:03 am
Jeff Moden (10/5/2012)
Perry Whittle (10/4/2012)
Generally I think that experience is a better measuring stick, sure you'll have exceptions but overall experience counts.
If I hadn't actually been through it, I'd absolutely...
"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
October 6, 2012 at 7:55 am
ERStudio from Embarcadero is my preferred 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
October 2, 2012 at 10:42 am
I don't agree with the initial construct. I've seen plenty of indexes with compound keys work perfectly well for performance without the need to add another column and another 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
October 2, 2012 at 10:41 am
patrickmcginnis59 (10/2/2012)
Grant Fritchey (9/21/2012)
Lowell (9/21/2012)
Grant wanted to avoid putting the answers on the forum, but i'd kind...
"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
October 2, 2012 at 10:25 am
Viewing 15 posts - 10,366 through 10,380 (of 22,232 total)