Viewing 15 posts - 18,421 through 18,435 (of 22,214 total)
As Lowell and I both said... No.
February 11, 2009 at 5:21 am
OK. So you want to pre-aggregate the data. This is an operation that is best done in the off hours. I'm not sure why you're so obsessed with the amount...
February 11, 2009 at 5:20 am
Great. Glad to hear it. It gave me a little blog post, so it's all good.
February 10, 2009 at 5:06 pm
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...
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...
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...
February 10, 2009 at 12:34 pm
MVIR (2/10/2009)
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...
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...
February 10, 2009 at 10:44 am
If it's disabled, you must be running the query on SQL Server 2000.
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...
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...
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...
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...
February 10, 2009 at 9:30 am
Viewing 15 posts - 18,421 through 18,435 (of 22,214 total)