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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2010 at 2:26 pm
I take it I'm not the only one irritated by the odd salutations around here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2010 at 12:46 pm
Post the stored procedures and the deadlock graph please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2010 at 10:59 am
CirquedeSQLeil (3/30/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2010 at 9:27 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2010 at 9:23 am
Please note that was a mistype and should have read SQL Server 2008.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2010 at 8:53 am
Viewing 15 posts - 33,271 through 33,285 (of 49,552 total)