SQL Server Questions Answered

Question: We’re seeing our weekly consistency checking job fail with lock timeout errors when it gets to checking tempdb. Why is this? I thought DBCC CHECKDB runs online now without locks? Answer: Yes, it is true that from SQL Server 200...

Question: I’ve been reading about wait statistics and I see that most scripts people have published filter out some of the wait types. Why is that? Surely all the wait types can be problematic and should not be ignored? Answer: The simpl...

Question: Is there any way for me to allow queries from certain users to have higher priority than queries from other users...

Question: We recently tried to attach a SQL Server 2008 R2 database to SQL Server 2012 and the upgrade failed because one of the filegroups in the database is set to read-only. When we tried to attach the database back to SQL Server 2008 R2 that...