Keyboard shortcuts with SSMS

SQL Server Management Studio allows you to set up custom keyboard shortcuts. These are a huge help, especially if you try out a few examples I’ve listed below. Firstly, you can get to the Keyboard menu from Tools > Options. SELECT TOP 100 If you…

Compare execution plans with SSMS

How have I not seen this before??!! If you have saved two execution plans in SQL Server Management Studio (SSMS), you can use the same tool to compare them! Check out the link below for more. https://blogs.msdn.microsoft.com/sql_server_team/comparison-tool-released-with-latest-ssms/