I’m using SQL Server Management Studio for a long time but it wasn’t until recently I discovered that it contains a feature called Template Explorer.
What is it?
Through Template Explorer you get access to a large list of scripts useful for a lot of scenario’s. Next time you want to google on how to execute a specific task, take a look at the Template Explorer first. There is a good chance that a script is already available.
Where can I find it?
To locate the templates in SQL Server Management Studio, go to View, click Template Explorer, and then select SQL Server Templates.
More information: https://docs.microsoft.com/en-us/sql/ssms/template/template-explorer