Viewing 15 posts - 10,366 through 10,380 (of 22,224 total)
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
Koen Verbeeck (9/28/2012)
laurie-789651 (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!Who is going to make it to any of the SQL in the City events coming up in the next week+?
If you 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
September 28, 2012 at 4:02 am
anthony.green (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!Who is going to make it to any of the SQL in the City events coming up in the next week+?
I missed the London one's due 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
September 28, 2012 at 4:01 am
And that's why we test.
The thing with trying to filter NULL values is that you're doing a function on it no matter what. By their nature, NULL values have no...
"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
September 28, 2012 at 4:00 am
When I've done it in the past, we were usually doing server consolidation, so we looked at the load on the server. We didn't break it down much by database...
"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
September 28, 2012 at 3:55 am
Excellent. Please post back with the results.
"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
September 27, 2012 at 3:28 pm
I think you're on the right track, yes. The function sure sounds like the primary cause.
As to the IN statement, with a really small one like this with hardcoded...
"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
September 27, 2012 at 10:10 am
THREADIZENS!
Who is going to make it to any of the SQL in the City events coming up in the next week+?
"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
September 27, 2012 at 9:03 am
You can also try XML. Parsing XML can be a somewhat memory intensive process, but moving that much data is already going to be memory intensive, so it might be...
"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
September 27, 2012 at 8:51 am
Viewing 15 posts - 10,366 through 10,380 (of 22,224 total)