In this post, I am going to share an important note about the READ COMMITTED isolation level and how it works with the READ_COMMITTED_SNAPSHOT option of SQL Server. The READ COMMITTED is the default isolation level of SQL Server, and it prevents the dirty reads. Your SELECT statements always returns committed data. It issues shared […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.