Gaps in Database ID sequence – one reason why this can happen

I spoke with a DBA today about the following scenario‚Ķ When running DBCC CHECKDB in SQL Server 2005, he noticed that there were no entries for the hidden database snapshot in sys.databases; however he did see that a database_id  value was shown when querying sys.dm_exec_requests (for the request running the DBCC command – WHERE command…

0

Updated SQL 2008 MCM Pre-reading list

David Ikeda and I have updated the SQL Server 2008 MCM Pre-reading list based on the last training rotation we conducted last October.  You can download the PDF here.  As a seasoned SQL Server professional, ideally you’ll already have read some, if not most of the material listed in this document.  If not, you’ll find…

0