Viewing 15 posts - 18,406 through 18,420 (of 22,202 total)
Do you mean you have 500 stored procedures that all have the same parameter and you want to change the data type? That's a pretty odd configuration.
Best bet would be...
February 11, 2009 at 5:50 am
Just a question, it says "SQL Server 200" is the last digit there a "0" or a "5"? If it's 2005, you can use TRY/CATCH to catch the deadlock error...
February 11, 2009 at 5:43 am
sp_msforeachdb is a cursor.
You can use the INFORMATION_SCHEMA system views. Specifically INFORMATION_SCHEMA.TABLES. These are common between SQL Server 2000, 2005 and 2008, so are a much better place to program...
February 11, 2009 at 5:39 am
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
Viewing 15 posts - 18,406 through 18,420 (of 22,202 total)