Viewing 15 posts - 11,986 through 12,000 (of 22,219 total)
GilaMonster (8/23/2011)
Ninja's_RGR'us (8/23/2011)
Ok but what makes you take that call? How can you tell that it's not the index that's @ fault to generate the bad plan?
Stats tell 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
August 23, 2011 at 5:43 am
Excellent code. Nice article. Well explained.
But I have to say, articles like this really do make me nervous. It seems like a very healthy percentage of our fellow database professionals...
"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
August 23, 2011 at 5:38 am
Ninja's_RGR'us (8/22/2011)
nawillia (8/22/2011)
"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
August 22, 2011 at 6:23 pm
Thanks. I just try to help out.
Hey, I like technical books too. Everyone at my old job thought I was weird when I picked up Kalen Delaney's SQL Server 2008...
"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
August 22, 2011 at 4:05 pm
Christi Wilson (8/22/2011)
"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
August 22, 2011 at 3:33 pm
I'd say that it's the XML that's killing you. Passing XML into a query is fine, but you should load it into temp tables as soon as possible. Constantly querying...
"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
August 22, 2011 at 3:25 pm
I don't know that I'd say that's always right, but yeah, that can be a great solution. Add the columns the the INCLUDE list of the index that was part...
"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
August 22, 2011 at 12:10 pm
EjSQLme (8/22/2011)
"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
August 22, 2011 at 12:06 pm
Christi Wilson (8/22/2011)
"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
August 22, 2011 at 12:03 pm
EjSQLme (8/22/2011)
Grant Fritchey (8/18/2011)
EjSQLme (8/18/2011)
Grant Fritchey (8/17/2011)
"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
August 22, 2011 at 11:41 am
Loner (8/22/2011)
I want to return all columnB.
Then I don't think columnb needs to be in the index at all. Since it's a clustered index, columnb is stored at the leaf....
"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
August 22, 2011 at 11:36 am
Indexed views are really only good if you have reasonably unvolatile data. If your data is being updated constantly then the indexed view is going to hurt more than it...
"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
August 22, 2011 at 11:20 am
Roy Ernest (8/22/2011)
"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
August 22, 2011 at 10:28 am
Yuri55 (8/22/2011)
Just to share my experience with 4.5 TB database backup -use Red Gate Sql Backup 5, compression- 2, backup locally first then move to remote storage
And does...
"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
August 22, 2011 at 10:26 am
Assuming the plan is absolutely identical, then it sounds like resource contention or blocking. No way to know anything though based on the information supplied. These are just guesses.
"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
August 22, 2011 at 10:18 am
Viewing 15 posts - 11,986 through 12,000 (of 22,219 total)