SQL Server error 17310

The problem Recently I had to migrate a SQL2005 database to a SQL2008R2 instance. So I picked up a copy of the database and restored in onto a test server. After restoring the database I changed a few settings (change compatibility mode, set page verify to checksum, changed recovery model) and ran … Continue reading

Trace flags in SQL Server

Introduction Trace flags in SQL Server allow you to change the behaviour of parts of SQL Server. Most information about trace flags can be found in several KB articles but usually this information does not provide too much detail. Warning Trace flags can lead to unexpected an undesired behaviour … Continue reading