Viewing 15 posts - 17,221 through 17,235 (of 22,226 total)
Roy Ernest (6/12/2009)
Isnt Subsonic better than nHibernate? Subsonic...
"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
June 12, 2009 at 8:19 am
Sounds like you need a LEFT join. That will return all from A and only those that match from B.
"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
June 12, 2009 at 8:11 am
simsr (6/12/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
June 12, 2009 at 8:08 am
Hard to know for sure, but hazarding a guess, your index was defragged, but the statistics were out of date, so rebuilding the index updated the statistics which fixed 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
June 12, 2009 at 7:32 am
This part of the code is going to cause problems:
WHERE
p.RegionID = COALESCE(@RegionID, p.RegionID)
AND
p.PriceBracketID = COALESCE(@PriceBracketID, p.PriceBracketID)
If you get index use ata ll on this table,...
"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
June 12, 2009 at 7:31 am
In Management Studio, check out View, Template Explorer. Scroll down & find Stored Procedures and the "Create Stored Procedure (New Menu)" script. Edit that and the next time someone...
"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
June 12, 2009 at 6:50 am
YAY!
Now if only people will read and follow the advice here.
Well done. Very nicely laid out and explained.
"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
June 12, 2009 at 6:16 am
RBarryYoung (6/12/2009)
Does anyone know of any...
"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
June 12, 2009 at 5:26 am
Jeffrey Williams (6/11/2009)
Grant Fritchey (6/11/2009)
I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior...
"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
June 11, 2009 at 1:45 pm
Nope.
This is a side-by-side test between Profiler & server-side traces by Linchi Shea. The difference is not to be sneezed at.
When the Profiler GUI runs, it attaches a memory latch...
"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
June 11, 2009 at 11:18 am
You will see contention between these two processes.
I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior to running backups.
"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
June 11, 2009 at 11:12 am
vaxn8r (6/11/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
June 11, 2009 at 9:32 am
No, I'm sorry. I didn't mean upgrade to SQL Server 2008. I meant upgrade to the GDR. I don't think there's any cost associated there. The functionality improvements in 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
June 11, 2009 at 9:15 am
The GDR is for 2008, but it changes the tool pretty radically in terms of deployment. It works great with 2005. I'd go for it if I were you.
I just...
"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
June 11, 2009 at 9:04 am
Yeah, I'd make sure you've got the SP for VS installed, but also, I'd strongly recommend getting the GDR version, which I think also has a service pack. It eliminates...
"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
June 11, 2009 at 8:42 am
Viewing 15 posts - 17,221 through 17,235 (of 22,226 total)