Monthly Archives: June 2012

Don’t believe everything you read: Reconfigure flushes the plan cache

I’ve been doing a fair bit of research and investigation into theĀ behaviorĀ of the plan cache recently. So I was concerned when I read somewhere that the reconfigure statement causes the SQL Server plan cache to be flushed. If this is … Continue reading

Posted in Plan cache, SQL Server, Uncategorized | Tagged , | 7 Comments

Corrupt Model database

An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was unable to be restarted because the data files were unavailable. Once the SAN was back online the instance still could … Continue reading

Posted in Disaster Recovery, SQL Server | 1 Comment

Service Broker: What does a DBA need to know?

Service Broker is SQL Server’s internal messaging system. It has been designed as an asynchronous, reliable and transactional messaging system for inter or intra database messaging, or even inter SQL instance messaging. It is a powerful tool for decoupling extended … Continue reading

Posted in Database options, Service Broker, SQL Server, T-SQL | 7 Comments