February 4, 2015 at 10:48 pm
Dear,
Somtimes I found very interesting things in my database. When I execute select statement on a particular table, some rows suddenly appear and disappear. So, I am not getting any clue what happened on that rows. I am using SQL Server 2008 R2.
Please help me to find out the clue. Thanks in advance.
February 4, 2015 at 10:54 pm
Is there any job running on the database performing DML operations , that might be the reason.
February 5, 2015 at 4:35 am
Any chance your query is using NO_LOCK?
That can absolutely lead to missing rows.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply