Viewing 15 posts - 17,206 through 17,220 (of 22,219 total)
GilaMonster (6/14/2009)
Grant Fritchey (6/14/2009)
Jeff Moden (6/12/2009)
I just saw the PASS session list. Congrats Gail and Grant!!!
Congrats to Gail and thanks.
I've got a spotlight and an alternate in the regular...
"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 14, 2009 at 8:56 pm
GilaMonster (6/14/2009)
Encountering that kinda attitude either in posts, PMs or emails makes me stop and ask myself why the hell I'm doing the forum thing in the first place.
I'd answer...
"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 14, 2009 at 10:05 am
GilaMonster (6/13/2009)
Florian Reischl (6/13/2009)
@Lynn, Jeff, Gail, ...Your guy from
http://www.sqlservercentral.com/Forums/Topic372527-146-1.aspx
Ended in
http://www.sqlservercentral.com/Forums/Topic734434-146-1.aspx
In all honesty, I couldn't care less. That type of attitude and replies makes me want to walk away and stop...
"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 14, 2009 at 5:18 am
Jeff Moden (6/12/2009)
I just saw the PASS session list. Congrats Gail and Grant!!!
Congrats to Gail and thanks.
I've got a spotlight and an alternate in the regular sessions.
It should 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
June 14, 2009 at 5:09 am
For recent commands that are likely still in cache, you can query cache directly through the dmv's
Running a query against sys.dm_exec_sql_text will let you search for delete statements or procedures....
"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 11:11 am
RBarryYoung (6/12/2009)
Actually, MAXDOP = 1 is the Microsoft recommended setting for OLTP environments, especially heavily loaded ones.
Hey Barry, If you start working with spatial data in 2008, you may find...
"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 10:35 am
Roy Ernest (6/12/2009)
Grant, Steve Thanks for the input. The Parameter size that is passed through with variable size,...
"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 10:32 am
simsr (6/12/2009)
What you're seeing is an artifact of the estimated cost values. SQL Server can't know how long a query is going to take to run, so the estimated cost...
"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:26 am
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
Viewing 15 posts - 17,206 through 17,220 (of 22,219 total)