Viewing 15 posts - 12,601 through 12,615 (of 22,219 total)
That's an estimated plan unfortunately, so there will be less data there.
You have tons of functions. I can't tell what's happening in here without seeing that code as well. It'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
May 3, 2011 at 4:16 pm
Raymond van Laake (5/3/2011)
Hehe, you're absolute right about testing! I certainly will, it's just @#$@$@##$@* busy here... but I know I must take the time to do the tests.Thanks!
Just imagine...
"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 3, 2011 at 12:00 pm
I agree, Red Gate SQL Compare. What's more, you don't have to run a restore. SQL Compare can read a backup and compare the backup to your 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
May 3, 2011 at 10:42 am
You have just discovered exactly why so many people caution so strongly against using nolock. It's just not a "run fast" switch as it keeps getting used.
"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 3, 2011 at 7:08 am
GilaMonster (5/2/2011)
Woot!!!!!!!!!!http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Well earned too. Congratulations! Nothing like knowing you have a reservation.
"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 8:28 pm
GilaMonster (5/2/2011)
Totally irrelevant and useless,...
"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 8:27 pm
GilaMonster (5/2/2011)
Please note: 4 year old thread
That's weird. It popped up on my RSS feed. I should only see new posts. I didn't even bother to check.
"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:41 pm
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
Viewing 15 posts - 12,601 through 12,615 (of 22,219 total)