Viewing 15 posts - 14,236 through 14,250 (of 22,224 total)
WayneS (9/30/2010)
Craig Farrell (9/30/2010)
CirquedeSQLeil (9/30/2010)
Grant Fritchey (9/30/2010)
CirquedeSQLeil (9/30/2010)
WayneS (9/30/2010)
CirquedeSQLeil (9/30/2010)
GilaMonster (9/30/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
September 30, 2010 at 7:29 pm
pshaship (9/30/2010)
I'm analyzing when exactly we required to perform Index defrag (Index reorg/rebuild) in SQL Server 2005 and I come across the article at mssqltips.com
which says:
Generally you should include...
"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 7:21 pm
CirquedeSQLeil (9/30/2010)
Grant Fritchey (9/30/2010)
CirquedeSQLeil (9/30/2010)
WayneS (9/30/2010)
CirquedeSQLeil (9/30/2010)
GilaMonster (9/30/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
September 30, 2010 at 7:11 pm
CirquedeSQLeil (9/30/2010)
WayneS (9/30/2010)
CirquedeSQLeil (9/30/2010)
GilaMonster (9/30/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
September 30, 2010 at 5:25 pm
I won't try to dissect the paging stuff. There are smarter guys than I am around here who can do that. But, I will point this out:
Where XML.value('(//BillNumber)[1]', 'varchar(10)')...
"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 5:24 pm
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
Viewing 15 posts - 14,236 through 14,250 (of 22,224 total)