Problem :
Most of the time, I find developers surrounded by hundreds of scripts and frantically looking for the required file amongst the open documents.
Given blew is the screen shots :
And also, it is near impossible that you are using all the documents at once. So, how to avoid this issue ?
Solution :
You just need to enable a very nice feature in SQL Server “Reuse current document window, if saved”. You can find this option in
Tools >> Options >> Environment >> Documents, as shown in the given below screen shot.
How it works :
You just need to enable this option and once it is enabled, just save the script which you have finished editing, and click on new query. So it will close the saved script (document) and open a new query in the same place.
Note : All the above screen shots are taken from SQL Server 2012.
SQL Server Portal 