Viewing 15 posts - 15,091 through 15,105 (of 22,221 total)
Unfortunately I don't have any funny names for code.
I do have two quasi-funny phrases that are used around here, a lot, too much.
The first, is a joke, say it, everyone...
"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 7, 2010 at 6:07 am
Everyone turning off parallelism is ignoring the fact that some queries can benefit. I strongly recommend you explore increasing the cost threshold of parallelism before you simply switch it off....
"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 7, 2010 at 6:01 am
Yep. They told me that leaving parallelism turned on (0 or some number greater than 1) and adjusting the cost threshold up is the way to go. I was told...
"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 6, 2010 at 1:09 pm
Frequently, but not always, it's not that the system can't benefit from parallelism, it's that the threshold for parallelism is set to low. The default, 5 I believe, is 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
May 6, 2010 at 12:59 pm
I'm with Steve. The only way I know to make transactions smaller is to... make the transactions smaller. Break apart the data in some fashion so that you're moving it...
"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 6, 2010 at 11:57 am
Steve Jones - Editor (5/6/2010)
GilaMonster (5/6/2010)
Grant Fritchey (5/6/2010)
"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 6, 2010 at 11:24 am
tymberwyld (5/6/2010)
"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 6, 2010 at 9:51 am
GilaMonster (5/6/2010)
Steve Jones - Editor (5/6/2010)
"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 6, 2010 at 9:47 am
Steve Jones - Editor (5/6/2010)
"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 6, 2010 at 9:02 am
Steve Jones - Editor (5/6/2010)
Lynn Pettis 1533
CirquedeSQLeil ...
"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 6, 2010 at 9:01 am
Tom Brown (5/6/2010)
"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 6, 2010 at 8:58 am
Steve Jones - Editor (5/6/2010)
Congrats, Grant. I wonder how many of those are in this thread. Hmmmm, maybe I should do a touch of analysis 🙂
It's probably only about 500...
"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 6, 2010 at 8:41 am
TheSQLGuru (5/6/2010)
I will add that as a consultant in the past 3-4 years I have...
"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 6, 2010 at 8:13 am
Gianluca Sartori (5/6/2010)
Grant Fritchey (5/6/2010)
And by the way, just passed 8000 points. #10 to do so.Now I'll let Jason & Paul pass me.
Congrats! It's a long way to 8000...
"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 6, 2010 at 8:10 am
SwedishOrr (5/6/2010)
I double checked to make sure I wasn't looking at two different event classes, and both are SP:StmtCompleted.HTH
If you're seeing two SP:StmtCompleted entries, then you've got two statements that...
"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 6, 2010 at 8:09 am
Viewing 15 posts - 15,091 through 15,105 (of 22,221 total)