Welcome to Sign in | Help

Browse by Tags

All Tags » sql » Troubleshooting   (RSS)
The SQL Server transaction log contains the history of every action that modified anything in the database. Reading the log is often the last resort when investigating how certain changes occurred. It is one of the main forensic tools at your disposal Read More...
A new error started showing up in SQL Server 2008 SP2 installations: The database cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported. 661 sure is earlier than 662, so what seems Read More...
Copyright Remus Rusanu 2010. Visit the original article at http://rusanu.com/2010/01/12/what-deprecated-features-am-i-using/   select instance_name as [Deprecated Feature] , cntr_value as [Frequency Used] from sys.dm_os_performance_counters Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/29/lockres-collision-probability-magic-marker-16777215/  @jrowlandjones blogged about a dubious deadlock case. I recommend this article as is correct and presents Read More...