Viewing 15 posts - 18,001 through 18,015 (of 22,226 total)
Derek (3/17/2009)
"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 18, 2009 at 6:03 am
I'm going to hell for this one, I just know it.
I was checking up on the status of what I think is a bug that I posted to Connect (Disabling...
"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 18, 2009 at 5:37 am
That's pretty inappropriate unless they're actively working on an upgrade which will come out shortly. VERY shortly.
"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 17, 2009 at 1:22 pm
It depends on the queries, but yes, indexes are extremely important. Most important is the clustered index. Here are several great articles on indexes by Gail Shaw [/url](GilaMonster). Even before...
"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 17, 2009 at 10:31 am
If you're indexes are badly fragmented, it can take a while. You're not experimenting on a live production database are you? That's a recipe for disaster.
"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 17, 2009 at 10:29 am
GilaMonster (3/17/2009)
Bob Hovious (3/17/2009)
"We're running out of time!"Cannot run out of time. There is infinite time. You are finite, Zathras is finite. This is wrong tool.
Good one.
"You take, Zathras die....
"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 17, 2009 at 9:29 am
Time And Relative Dimensions In Space...
Of course, I do have a sonic screwdriver in my backpack, so I might be biased.
"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 17, 2009 at 9:05 am
Jack Corbett (3/17/2009)
GilaMonster (3/17/2009)
Bob Hovious (3/17/2009)
"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 17, 2009 at 8:18 am
Also remember that those estimated costs, are estimated, not actual. Execution can be quite a bit different than what is represented, and in a good 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
March 17, 2009 at 5:25 am
Sounds like you have the Resource Governor in place. I'm not that familiar with it, but I would suspect there would be some way to set this query to 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, 2009 at 7:44 pm
Well done and congratulations. Deliver on half the list and you've earned your raise for the year (and you have an agenda for next year).
"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, 2009 at 7:37 pm
I have not personally done an upgrade in that fashion. Based on my understanding of how it works, yes, but that's from reading documentation. If you want to be absolutely...
"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, 2009 at 12:37 pm
That's a huge topic. First, you need to figure out what is causing the performance to slow down. Since, at this point, you're completely in the dark, I'd suggest taking...
"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, 2009 at 9:31 am
Jack Corbett (3/16/2009)
"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, 2009 at 8:16 am
That's a huge topic. First, you need to figure out what is causing the performance to slow down. Since, at this point, you're completely in the dark, I'd suggest taking...
"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, 2009 at 8:12 am
Viewing 15 posts - 18,001 through 18,015 (of 22,226 total)