MS SQL: Bad Ju-Ju Magic

I call for a vote of no confidence... Running the statement select count(*) from BagLocations returned the value 19 014 584. Then I started the following query: insert into BagLocations_JuganTemp select * from BagLocations Then, while that was running (it ultimately took 6:33), I ran select count(*) from BagLocations which returned about 3 000 000. Then, once the long-running query completed, I ran select count(*) from BagLocations which returned 19 014 584 again, as did select count(*) from BagLocations_JuganTemp. Ju-ju bad. Verry badd.

Read More