What is a dirty read?

Dirty read is caused when the TRANSACTION ISOLATION LEVEL is set to READ UNCOMMITTED. This isolation level neither issues a shared lock nor issues exclusive locks. The statements in the current transaction can modify the data that has not been committed by other transactions. It leads to the removal or change in the data before the completion of the current transaction. The shared and exclusive locks prevent the statements in the current transaction to read the data that has not been committed by other transactions.

• Download free practice test for mcad MCAD exam.
• Download free practice test for Microsoft MCITP exam.
• Best exam simulation Microsoft mcitp-database-administrator download free trial.
• Best exam simulation Microsoft mcitp-database-administrator-sql-server download free trial.
• Download free practice test for mcitp-database-admin-sql-server-2005 MCITP Database Administrator SQL Server 2005 exam.
• Become Microsoft MCITP Microsoft SQL Server certified.
• Download free practice test for Microsoft MCP exam.
• Download free practice test for Microsoft MCSA 2000 to 2003 exam.
• Get certified in first attempt download mcsa-to-mcse-2003 - MCSA to MCSE-2003 simulation.
• Click here to download mcse-2003 test study guide and practice question.
• Click here to download mcts-sql-server-2005 test study guide and practice question.
• Pass SQL Server 2005 Implementation in first attampt.
• Become Microsoft SQL Server 2005 Optimizing and Maintaining certified.
• Download free practice test for 70-447 SQL Server 2005 Design exam.

• Previous Entry: SQL Server Profiler
• Next Entry: What is a transaction log?