alex.palmer - Wednesday, December 20, 2017 6:00 AM
That's not even close, it compares serializable to snapshot and as I said RCSI works very differently to SI.
Grant Fritchey - Wednesday, December 20, 2017 7:08 AM
Defining what "correct" results look like is very entertaining. I've worked with people who put WITH NO_LOCK on every single query in the system. When they finally start using RCSI, they also start getting "incorrect" data. In fact, they were eliminating duplicate rows and adding back in missing rows, not to mention getting more consistent results. However, the business wasn't seeming the same results so they got very concerned
you feel my pain then too Grant 😀
alex.palmer - Wednesday, December 20, 2017 7:20 AM
Yes, size it and ensure it's going to be at best performance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉