Yep... for now.  Your company should really work on normalizing the keyword lookup instead of it being in a CSV.  Then it wouldn't only...

You using regurgitated OLTP procs because you don't want to or won't make the time to do it right...

Does someone have a trace running or some monitoring software that does?

Have you contacted Microsoft about this issue?

Here is a nice reference by Brent Ozar regarding RCSI: "Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide"

Have a look at the "Gotchas With...

Thank you for the feedback and welcome aboard!

I'm going to be a wee bit more blunt that...

IIRC, RCSI adds 14 bytes to every row and that's likely going to cause a 50% page density and a high degree of logical fragmentation to be present right after...

That post is now more than 2 months old.  The moment has kinda been lost. 😉

To summarize, I was asking you to outline the exact steps and code you were...

I have to admit that I'm a bit gobsmacked at the number of people (50% at the time of this posting) that think there's such a thing as DATEADD(time,.....

Heh... it's a real shame that MS didn't follow the ISO/ANSI standards when it came to the "new" (now old) DATE, TIME, and DATETIME2 datatypes and it's also a shame...

I'm not sure if I had any declared goals even on New Year's day except to quit smoking and that NEVER worked.  I usually declare goals when I realize that...

All that being said, I'm scared to death of moving from 2016 to 2019 next year and MS has done nothing to quell the ongoing fears associated with...

Yeah... absolutely confirmed.  I'm definitely not getting any email notifications.

Heh... I kinda knew that. 😀