March 7, 2012 at 8:57 am
Hi,
A colleague of mine came across a strange scenario, picture this.
We have a table called TableA, it has a handful of records in it, lets say 7.
A user runs a delete statement to remove 1 record.
Another users runs a select to return the contents of the table but they get zero records returned.
All very odd you may think, however if a user then runs a stat update on the table, then the second user re-runs their select, they then get the 6 records back, as expected.
I've never seen this before, does anyone know why this would happen?
Thanks,
Nic
March 7, 2012 at 12:29 pm
Never heard of such a thing happening.
How long does the delete take?
What are the indexes?
What is the locks taken by the delete?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply