To get the best performance and proper lock ordering for concurrent updates I usually need to resort to using a variety of MSSQL only SQL extensions. (Lock hints, isolation levels, specific join methods, etc)

Is there a list of exactly what coverage this has? Does it support pinning execution plans?

Here’s an example of the crap I had to resort to in my last big project: https://github.com/realartists/shiphub-server/blob/master/Re...