Month: April 2017

ALTER DATABASE SET READ_COMMITTED_SNAPSHOT is running forever
By: Date: April 16, 2017 Categories: READ_COMMITTED_SNAPSHOT

When working with a busy database you might run into problems when you want to change a database setting which requires the database to be in a consistent state, meaning no uncommitted transactions and no schema or table locks. Ideally the application(s) using the database should be offline for such a change but for cases…

Read More →