Viewing 15 posts - 11,146 through 11,160 (of 22,219 total)
Steve Jones - SSC Editor (4/5/2012)
chrisn-585491 (4/5/2012)
I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making...
"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
April 5, 2012 at 9:04 am
steve.hansen (4/5/2012)
"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
April 5, 2012 at 7:23 am
Gary Varga (4/5/2012)
chrisn-585491 (4/5/2012)
I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making SQL Source Control....
"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
April 5, 2012 at 7:20 am
chrisn-585491 (4/5/2012)
I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making SQL Source Control. The fact...
"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
April 5, 2012 at 7:17 am
G Bryant McClellan (4/5/2012)
"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
April 5, 2012 at 7:04 am
The function, is a multi-statement table valued function? If so, eliminating that may be the best bet for tuning the query.
To share a plan, save it as a .SQLPLAN file...
"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
April 5, 2012 at 6:24 am
If you have really severe data skew, you need to evaluate it. Is the situation such that there are a few bad possibilities? If so, you can look to use...
"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
April 5, 2012 at 6:17 am
You're doing JOIN to other views. That is one seriously problematic model. I strongly recommend against it. You're shooting the optimizer right in the foot before asking it to...
"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
April 5, 2012 at 5:49 am
That's a very large topic. I have one chapter of my performance tuning book focused on the important metrics you need to collect. I really don't want to replicate 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
April 5, 2012 at 5:45 am
Stats get created any time a column is referenced in a WHERE or JOIN criteria. It doesn't necessarily mean anything.
I would take any and all suggestions from the DTA with...
"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
April 5, 2012 at 5:43 am
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.
If I...
"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
April 5, 2012 at 5:30 am
Koen Verbeeck (4/5/2012)
SQLRNNR (4/4/2012)
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspxA lot of attitude on that one.
I think the attitude comes from a lot of frustration.
Yeah, I feel for him....
"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
April 5, 2012 at 5:23 am
anthony.green (4/5/2012)
could you not create a secondary version of 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
April 5, 2012 at 5:21 am
I'd probably go with using extended events to audit the changes, but I can see how that might be difficult to see what's changed when, etc.
So, let's think outside 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
April 5, 2012 at 5:20 am
call.copse (4/5/2012)
"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
April 5, 2012 at 5:10 am
Viewing 15 posts - 11,146 through 11,160 (of 22,219 total)