Viewing 15 posts - 18,436 through 18,450 (of 22,226 total)
Alvin Ramard (2/10/2009)
Psychology:
"I have a client who is a DBA and suicidal. What do I tell them?"
You don't have to worry about that one. His problems will go...
"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
February 10, 2009 at 4:58 pm
Yep, Gail's right on this one too (you can usually just assume that).
The only thing cached is the expanded query, which again, the query against the table is cached 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
February 10, 2009 at 1:28 pm
If you mean that the database goes away due to a media failure and you were unable to backup the log file, then you can only restore up to 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
February 10, 2009 at 12:34 pm
MVIR (2/10/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
February 10, 2009 at 11:12 am
Took a little bit of experimentation, but this worked. Right click on the tab, change the window to floating. It will detach and be somewhere on your screen. Right click...
"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
February 10, 2009 at 11:08 am
Unfortunately, that image is just shy of useless.
You're getting index scans. That means that the index is not being used effectively. Index scans & hash joins pretty much indicates that...
"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
February 10, 2009 at 10:44 am
If it's disabled, you must be running the query on SQL Server 2000.
"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
February 10, 2009 at 10:41 am
b.larochelle (2/10/2009)
Thx for the advice,If i recap
- By turning the Autoshink Off i will increase the performance, however the transaction will still get empty after the Full backup ?
The transaction...
"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
February 10, 2009 at 10:39 am
It sounds like you're maxing out the transactions. You're in simple recovery mode, so completed transactions should be removed from the log at the checkpoints. To max out the log...
"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
February 10, 2009 at 9:37 am
If you can, post the structure and the execution plan. Just because the DTA didn't find a good index doesn't mean one shouldn't be created. That tool is spotty at...
"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
February 10, 2009 at 9:34 am
Can you post the actual execution plan?
I'd be surprised if you're getting good index usage since you're running several functions against the columns in the WHERE clause, including ISNULL...
"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
February 10, 2009 at 9:30 am
Yes.
"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
February 10, 2009 at 9:11 am
GilaMonster (2/10/2009)
Grant Fritchey (2/10/2009)
Wait, no I didn't. More coffee, that's the answer.
More coffee is an acceptable answer to many problems. I didn't read your post in detail, so I don't...
"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
February 10, 2009 at 8:45 am
tknight (2/10/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
February 10, 2009 at 8:41 am
Grant Fritchey (2/10/2009)
GilaMonster (2/10/2009)
tran008 (2/10/2009)
so if I put the order by in the view...both select statement in general perform the same?
If you put just an order by one 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
February 10, 2009 at 8:26 am
Viewing 15 posts - 18,436 through 18,450 (of 22,226 total)