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 hint

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/RealArtists.ShipHub.Database/Procedures/BulkUpdateIssues.sql https://github.com/realartists/shiphub-server/blob/master/Re...