Hi

sorry I've wasted your time.  I looked at the column definitions and the data types where different.

Once I casted the nchar to a char and the...

Yep! I've done exactly that and I still get a table scan

Thanks for the reply

This is a production server so I'd be taken out and shot if I tried to replicate the issue on it. We've not been able...

That's what my management are scarred of.  A process we're not aware of battering the table and the new addition  making performance collapse.

Have you ever used any tools...

Wow......

Thanks for that John. It's at the end of my working day now but I'll try and understand how that all hangs together tomorrow.

Update

I tried running as above. The setup exe's executed as the local admin account but it still bombed out with the same errors.

I also tried running...

Thanks for your persistence Sue, that link set me off looking again.

This looks like it will work

First on the device I was running...

If memory serves.......

I created  a local admin account of the box I was deploying SQL to, Then in the PowerShell script I created a credential for that...

Thanks for the reply Sue.  I've already tried that approach and I get the same results

Thanks for all the replies, they definitely give me food for thought.

Ok, then back to my original question.......

Do you have any advice on how to identify code that might suffer from the issue described, or guidance of the kind...

Straight off the bat I worry that the overnight batch processes may "rely" on SELECTs being blocked by UPDATEs for consistent results.

Also everything else I read says Optimistic Locking...

Interesting.........

What would you consider "due diligence" before switching it on then?

I guess there's tempdb considerations, but anything else apart from that?

Read this link and then tell me I don't need to be concerned about code 😉

https://blogs.msdn.microsoft.com/craigfr/2007/05/16/serializable-vs-snapshot-isolation-level/

I know to enable it I just a drop down  in...

Hi Perry

Thanks for he reply. I know what RCSI is and the difference between that and the isolations level is

My question is around reviewing existing code...