Dropped an index but SSMS still underlines it in red? Press CTRL + SHIFT + R to refresh the SSMS Intellisense cache and pick up your schema changes.
Compare Showplan: Finding What Changed Between Two Plans
Compare Showplan shows where two plans differ, but not why. Here is a small before and after example you can run yourself.
SQL SERVER – How to Set Variable and Use Variable in SQLCMD Mode
A reader asked how to pass a different table name each time in SSMS. I show how to set and use a variable in SQLCMD mode with :SETVAR, step by step.
SQL SERVER – Another lesser known feature of SQL Server Management Studio 2012 – Guest Post by Balmukund Lakhani
Balmukund Lakhani shows another lesser known feature of SQL Server Management Studio 2012, hidden in the Connect to Server screen you see every day.
SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani
Balmukund Lakhani turns his popular SQL Bangalore UG session into a guest post: the story of the -m startup parameter and a lesser known way to use it.
Sharing Query Results From SSMS: Copy With Headers, Grids and CSV
Share SSMS results with copy with headers, text and file output, deliberate CSV quoting, and command-line exports for larger sets.
Remove a Cached Connection in SSMS: SQL in Sixty Seconds #049
To remove a cached connection from the SSMS Connect dialog, delete the entry from the Server name list. The tests here show that the list lives on the client, how three entries can reach one server, and how to check where an old entry points before you delete it.