I generally find it irritating to try and scroll through a multi-query batch/stored procedure to look at a single execution plan because the scroll bar in a scroll bar is not a great experience. If you have a batch you are running that has some iterative logic it will generate a lot of plans and […]
Read MoreSSMS
Connecting to a read only replica with SSMS
If you are using always on availability groups and need to connect to a read only replica, you might get the following error message in SSMS: Msg 978, Level 14, State 1, Line 1 The target database (‘Database’) is in an availability group and is currently accessible for connections when the application intent is set […]
Read MoreHow 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