Viewing 15 posts - 12,616 through 12,630 (of 22,227 total)
SQLRNNR (5/2/2011)
Grant Fritchey (5/2/2011)
GilaMonster (5/2/2011)
Grant Fritchey (5/2/2011)
Steve Jones - SSC Editor (5/2/2011)
Brandie Tarvin (5/2/2011)
I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about...
"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
May 2, 2011 at 3:37 pm
A guide for people to write their own queries? Completely unqualified people? No. I wouldn't suggest that. Instead set up a reporting system with templates and models that they 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
May 2, 2011 at 3:36 pm
Without the execution plan the only thing that really leaps out at my eye is the use of DISTINCT in the derived tables. That can frequently be a crutch for...
"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
May 2, 2011 at 3:33 pm
To me a design document would include an entity relationship diagram, probably a logical, not a physical model, naming standards, coding standards, descriptions of acceptable data loss for the business,...
"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
May 2, 2011 at 3:28 pm
GilaMonster (5/2/2011)
Grant Fritchey (5/2/2011)
Steve Jones - SSC Editor (5/2/2011)
Brandie Tarvin (5/2/2011)
I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones...
"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
May 2, 2011 at 3:23 pm
Steve Jones - SSC Editor (5/2/2011)
Brandie Tarvin (5/2/2011)
I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones at SSIS Guy...
"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
May 2, 2011 at 2:38 pm
Without more information it's hard to know. I'd suggest going after the wait states to see what's causing stuff to slow down. But you should also check that the system...
"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
May 2, 2011 at 6:44 am
Why do you have multiple party types? What's the point?
But, to get all party information back, probably the best way is a UNION ALL query where you join each individual...
"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
May 2, 2011 at 6:42 am
Yeah, the best performance tuning questions come up on here, all the time. But you can also look at my blog, Paul White's blog[/url], Gail Shaw's blog, and pick up...
"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
May 2, 2011 at 6:38 am
Steve Jones - SSC Editor (5/1/2011)
http://www.sqlservercentral.com/Forums/Topic1101142-146-1.aspx#bm1101269
I can certainly appreciate he/she is annoying, and not...
"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
May 2, 2011 at 5:48 am
To post the plans you can save it as a .sqlplan file and then upload it.
If you're seeing differences, then these are different plans. Without seeing the plans, it's hard...
"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
April 29, 2011 at 1:16 pm
I haven't heard anything publicly that would indicate it. If I had heard anything privately I couldn't tell you about it (but I haven'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
April 29, 2011 at 1:01 pm
That's the right flag. I just did a full test to validate, incrementals are created by having this off. Do you have your target set appropriately? If the target is...
"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
April 29, 2011 at 8:02 am
I just talk about the information on a form, like a drivers license. It all gets stored somewhere and I'm the guy that manages the stuff that does the storing.
"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
April 29, 2011 at 5:52 am
Dropping all indexes may help with the inserts, but then again it might not. It really depends on if any of them are necessary for lookup operatoins during the inserts....
"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
April 29, 2011 at 5:47 am
Viewing 15 posts - 12,616 through 12,630 (of 22,227 total)