April 15, 2014 at 4:22 pm
Hi all,
I noticed some situation when we delete some records in a table, but the count from that table still shows for some time.
The situation is pretty simple. We have a job that periodically selects * from table A and inserts them into B, and then deletes A. All this done in a transaction. However, if I select count from A it still shows the same number of records just like nothing was deleted. It misled me to idea that that table was blocked. However I checked in sys.sysprocesses and nothing was actually blocked. Then, in about a minute or so I checked count of records again, it finally showed 0.
And this behavior happend several times already. Our version is 2008 R2. The database in bulk-logged recovery model. Trans isolation level is not set in the job code. Number of records usually between 50,000 and 100,000. Job history shows durations from 0 to 17 sec.
What else can I check? And how to explain this phenomenon ?
Thanks
April 15, 2014 at 7:03 pm
Just curious, but could you post the actual code you use to complete the counts?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply