Viewing 15 posts - 17,206 through 17,220 (of 22,226 total)
Lynn Pettis (6/15/2009)
Actually, not much of a Baseball fanatic, but it looks like the Rockies are doing good so far.
Actually, I could care less about baseball too.
Hey, BBC America 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
June 15, 2009 at 7:08 am
If you're not already collecting performance data using a server-side trace (which you can define through Profiler, just don't run it from the GUI), you should start.
As was stated above,...
"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 15, 2009 at 6:54 am
ubernoob (6/14/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 15, 2009 at 6:15 am
Low Rider (6/14/2009)
I have a schecdule job which reindexes the table every 4:00 Am and for now have scheduled it for every 8:00 AM,but still the same result.I am ...
"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 15, 2009 at 5:29 am
ubernoob (6/14/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 14, 2009 at 9:07 pm
Paul White (6/14/2009)
RBarryYoung (6/14/2009)
What shall we name it? 😛
Oh. Mine is rather dull: Smelly Armpit Troll
I'm sure, with a bit of effort, I could be worth...
"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 9:04 pm
Jeff Moden (6/14/2009)
Grant Fritchey (6/14/2009)
I've got a spotlight and an alternate in the regular sessions.
"Regular Sessions"? Are you talking about "general" sessions? I've not received anything one way...
"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:58 pm
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
Viewing 15 posts - 17,206 through 17,220 (of 22,226 total)