Viewing 15 posts - 15,706 through 15,720 (of 22,226 total)
Yeah, it was absolutely top notch. Too bad he didn't write it for the Standard. I would have paid more. 😀
"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
March 16, 2010 at 6:48 am
Don't get hung on OLTP = no paralellism. I've seen it go both ways. I agree with George (stop banging your head). Most of the time the cost setting 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
March 16, 2010 at 6:39 am
I may as well pile on here since we clearly don't have a consensus.
Either will work.
Either will work with multiple servers, multiple databases, etc.
However, PowerShell offers much more flexibility and...
"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
March 16, 2010 at 6:33 am
It's possible. All those ISNULL functions on your columns are going to absolutely kill performance. Have you looked at the execution plan for the query, both on the fast servers...
"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
March 16, 2010 at 6:27 am
I agree, the best skill you can begin to develop immediately is the ability to do a search. Remember, you're not the first person down this path. Actually, it's not...
"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
March 16, 2010 at 6:24 am
Excellent article. You made several points and made them well, not the least illustrating why "it depends" is such a common statement.
"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
March 16, 2010 at 6:11 am
Well done Lynn
"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
March 16, 2010 at 6:04 am
Jack Corbett (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age...
"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
March 16, 2010 at 5:29 am
CirquedeSQLeil (3/15/2010)
george sibbald (3/15/2010)
Always amazed me how...
"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
March 16, 2010 at 5:28 am
GSquared (3/15/2010)
Roy Ernest (3/15/2010)
Happy B'Day Grant...And Gus Belated B'day wishes for you.
Thanks. 🙂
Absolutely. Belated best wishes.
"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
March 15, 2010 at 10:58 am
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age...
"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
March 15, 2010 at 9:42 am
Steve Jones - Editor (3/15/2010)
Happy Birthday, Grant, from SQLServerCentral!
Thanks Steve.
"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
March 15, 2010 at 9:41 am
Thanks to all the denizens of The Thread.
Now go answer SQL Server questions.
"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
March 15, 2010 at 9:33 am
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If...
"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
March 15, 2010 at 9:32 am
Luke L (3/15/2010)
Happy Birthday Grant. Don't have too much fun today 😉Cheers,
-Luke.
No worries there. Work then off for the SNESSUG meeting. No chances of having too much fun.
"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
March 15, 2010 at 9:30 am
Viewing 15 posts - 15,706 through 15,720 (of 22,226 total)