Viewing 15 posts - 14,011 through 14,025 (of 22,224 total)
Brandie Tarvin (10/28/2010)
I should have sent Grant some of my eyeballs. Then he'd feel like he was being watched.Or he would have been too busy eating them to talk. @=)
Yeah,...
"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
October 28, 2010 at 12:39 pm
Actually, I'm right. You can't load it that way. Here's a discussion on the Microsoft forums.
"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
October 28, 2010 at 12:29 pm
I'm pretty sure it's because that reference is incorrect. Microsoft.SqlServer has two other classes. Server and Management, in PowerShell. I suspect you'll have to create the object a different 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
October 28, 2010 at 12:27 pm
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!
Oh, that was you? Sorry I didn't wave back. Man, I need to work on...
"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
October 28, 2010 at 11:06 am
jcrawf02 (10/28/2010)
Steve Jones - SSC Editor (10/27/2010)
If you have ideas, feel free to post them, but try...
"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
October 28, 2010 at 6:36 am
Jeff Moden (10/28/2010)
Task complete. Submitted article via "Write For Us".
Over-achiever.
"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
October 28, 2010 at 5:45 am
I'll write up something on this.
"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
October 28, 2010 at 5:44 am
Steve Jones - SSC Editor (10/27/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
October 28, 2010 at 5:37 am
Jeff Moden (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Grant Fritchey (10/27/2010)
Look for the tall bald guy in a red vest.Or the hairy legs under a short
skirtkiltGAH!!!! 😀
Oh squid...
"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
October 28, 2010 at 5:34 am
Steve Jones - SSC Editor (10/27/2010)
- Finding/changing the default backup location
- scheduling a trace
- duplicating...
"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
October 27, 2010 at 11:17 am
Jack Corbett (10/27/2010)
Grant Fritchey (10/27/2010)
Please, make sure, if you're going to the Summit, you track me down and introduce yourself in person. Some of you I know already,...
"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
October 27, 2010 at 11:05 am
Steve Jones - SSC Editor (10/27/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
October 27, 2010 at 11:04 am
Steve Jones - SSC Editor (10/27/2010)
I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere...
"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
October 27, 2010 at 10:48 am
That's... a lot. I'm not going through all of it in detail. Summary: Tons of key lookup operations. Every one of those is probably hurting your performance. You need 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
October 27, 2010 at 7:41 am
SureshS_DBA (10/27/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
October 27, 2010 at 7:02 am
Viewing 15 posts - 14,011 through 14,025 (of 22,224 total)