Scenario:You have written long TSQL script in SSMS. You are in process of debugging and want to take a look on start and end of code at the same time. You don't have two monitor available. Is it possible if I can split window to see the same code and take a look in different parts of code at same time?
Solution:SQL Server Management Studio (SSMS) does provide the facility to split Query window so you can take a look at different parts of code.
You will see a small button at Right Upper Corner in your query window as shown below.
Press the button and drag it down and you will see the single window will split into two windows and now you can scroll in them independently.