Viewing 15 posts - 13,996 through 14,010 (of 22,219 total)
There are a number of cases, certainly not a majority by any stretch of the imagination, where performance is worse in 2008 than it is in 2000. Usually this 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
October 29, 2010 at 6:52 am
Hey everyone. I'm positive one or more of you can help this guy
"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 29, 2010 at 6:46 am
I haven't a clue about this, so I'm going to call in some reinforcements. Stand by.
"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 29, 2010 at 6:44 am
Another option to creating an index is to create statistics. However, neither index nor statistics can be created and then automatically dropped. Any create requires a subsequent drop action 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 29, 2010 at 6:43 am
Assuming my family history, location, and birth would be roughly equivalent, unfortunately, farmer. I'm actually part of the first generation in my family going back 200 years on my fathers...
"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 29, 2010 at 5:47 am
Jeff Moden (10/28/2010)
Brandie Tarvin (10/28/2010)
Now I'm obsessing about...
"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 29, 2010 at 5:26 am
GilaMonster (10/28/2010)
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.
At least you didn't take on an hour and a half presentation...
"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 29, 2010 at 5:20 am
Luke L (10/28/2010)
Grant Fritchey (10/28/2010)
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...
"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 29, 2010 at 5:18 am
Chad Crawford (10/28/2010)
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 12:45 pm
That's a very abnormally long time. I'd suggest taking a look at the sys.dm_exec_requests, just as a start, to see what is causing the process to wait, because it must...
"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:41 pm
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
Viewing 15 posts - 13,996 through 14,010 (of 22,219 total)