Viewing 15 posts - 14,236 through 14,250 (of 22,219 total)
I asked around and the consensus seems to be that, because of filtered indexes and sparse columns, the number of indexes in support of larger tables using these new constructs...
"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
September 30, 2010 at 1:38 pm
If it still doesn't work, post back here. I'll try to see if I can get it to work too.
"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
September 30, 2010 at 1:01 pm
I couldn't agree more with Joe on this one. You're really bashing your fingers with a hammer.
While there are situations where breaking up statements and using a temp table can...
"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
September 30, 2010 at 12:51 pm
Express12 (9/30/2010)
select top 5
sum(qs.total_worker_time) as total_cpu_time,
sum(qs.execution_count)...
"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
September 30, 2010 at 12:46 pm
It sounds like the DTA is not connecting to the right database. That would explain why it's getting that error.
"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
September 30, 2010 at 12:33 pm
According the Microsoft rep here[/url], you should only see the GO statements where they're required. Is that not true? Have you tried testing the script generated?
"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
September 30, 2010 at 12:22 pm
CirquedeSQLeil (9/30/2010)
WayneS (9/30/2010)
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or a ticket :-P:w00t:
If he's in his...
"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
September 30, 2010 at 11:52 am
jackimo (9/30/2010)
I do understand that and the fact is in some cases we'll have to do a full scan. Do you think that storing the message in a...
"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
September 30, 2010 at 11:39 am
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or a ticket :-P:w00t:
Or? Or a ticket. Okay. I'll...
"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
September 30, 2010 at 11:35 am
And there's a table scan:
CONVERT(DATETIME,LEFT(CONVERT(VARCHAR, b.event_time, 120),10))
Having a function on the column means that SQL Server can not know what the value is, and must scan the available values...
"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
September 30, 2010 at 9:12 am
inevercheckthis2002 (9/30/2010)
Edogg (9/29/2010)
Log backups do not shrink the transaction log.Please read through Gail's article on transaction logs. It should clear up any questions you have.
Edogg said: "Log backups do 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
September 30, 2010 at 8:34 am
Last couple of years they've had craps, & blackjack that I remember. I think there might have been a roulette wheel too. I like to play craps, as long as...
"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
September 30, 2010 at 8:31 am
Oliiii (9/30/2010)
You can do a select on sys.spatial_indexes to get all the spacial indexes (which you'll most likely never use).
Never is a big word. Where I work is already making...
"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
September 30, 2010 at 8:30 am
Gianluca Sartori (9/30/2010)
Jack Corbett (9/30/2010)
Gianluca Sartori (9/30/2010)
This is a statement generated by our BI front-end.
Surprisingly enough,...
"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
September 30, 2010 at 8:15 am
I have a few scripts on my blog, but if you really want to see stuff, you need to read Allen White's blog, Buck Woody's blog, Aaron Nelson's blog, 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
September 30, 2010 at 8:13 am
Viewing 15 posts - 14,236 through 14,250 (of 22,219 total)