How to change your default transaction isolation level in SSMS

It’s not uncommon for me to see support professionals running SELECT queries against production databases that cause major performance issues due to shared locks.  By default SQL Server Management Studio (SSMS) has its transaction isolation level set to READ COMMITTED.  If your support users only have read access to your database I would suggest having […]

Read More