Viewing 15 posts - 33,271 through 33,285 (of 49,552 total)
There's a little on SIX locks here - http://msdn.microsoft.com/en-us/library/ms175519.aspx. Trying to dig up more clear comments.
March 30, 2010 at 2:31 pm
Jeff Moden (3/30/2010)
AspiringGeek-40457 (3/30/2010)
I can guarantee that training is *not* a profit center for Microsoft.
Unless you work for Microsoft or have a Microsoft URL stating that, I'm pretty sure you...
March 30, 2010 at 2:26 pm
I take it I'm not the only one irritated by the odd salutations around here.
March 30, 2010 at 2:20 pm
Before you declare it SEP1, check the procs that call these, and any that call those, etc and make sure that there's no explicit BEGIN TRANSACTION in them.
(1) Someone else's...
March 30, 2010 at 2:20 pm
The deadlock graph mentions a user transaction, and neither of the procs that you've posted start or commit a transaction. There's a proc called earlier, somewhere, that starts a transaction...
March 30, 2010 at 2:12 pm
Also http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
Not as well written as the articles.
March 30, 2010 at 12:46 pm
Post the stored procedures and the deadlock graph please.
March 30, 2010 at 12:43 pm
cos_ta393 (3/30/2010)
Basically the db's are set to simple recovery and the first task after restoring a production copy is to dump the log.
If the database is in simple recovery, you...
March 30, 2010 at 12:39 pm
CTEs and table variables are totally different.
A table variable, like a temp table, is a table in TempDB, kept in memory if possible, spilt to disk if not.
A CTE,...
March 30, 2010 at 10:59 am
CirquedeSQLeil (3/30/2010)
March 30, 2010 at 10:49 am
Why the hell are you truncating your log and shrinking your database?
Please read through this - Managing Transaction Logs[/url]
Shrinking causes massive fragmentation and will just result in the data file...
March 30, 2010 at 9:27 am
Please note that was a mistype and should have read SQL Server 2008.
March 30, 2010 at 9:13 am
vidya_pande (3/30/2010)
Database may go into recovery while restore. Never seen while backing up. :hehe:
It's possible. There's a documented option to backup to do just that.
March 30, 2010 at 9:12 am
Interesting... The error is in the snapshot that checkDB creates and uses...
I've referred this to a corruption expert for assistance. It may be necessary to restore from your last...
March 30, 2010 at 8:53 am
Viewing 15 posts - 33,271 through 33,285 (of 49,552 total)