Product:
Microsoft SQL server 2019
Issue:
How find what SQL Query is it that i is working one?
Solution:
When you have a long list of Query’s you work with, click on the little PIN one each and they will stay at the top. And maybe it is easier for you to find back to the one you want to work with.
Other tip is to use WHERE 1=1 in your statements, to easy then remark the lines you need or not need when you adjust your selection.
SELECT TOP (1000) [GeographyKey] ,[City] ,[StateProvinceCode] ,[StateProvinceName] ,[CountryRegionCode] ,[EnglishCountryRegionName] ,[SpanishCountryRegionName] ,[FrenchCountryRegionName] ,[PostalCode] ,[SalesTerritoryKey] ,[IpAddressLocator] FROM [AdventureRestore].[dbo].[DimGeography] WHERE 1=1 and CountryRegionCode = 'AU' --and city = 'Alexandria' and PostalCode = 2015
More Information:
https://www.red-gate.com/simple-talk/wp-content/uploads/imported/1307-keystrokes.pdf
https://sqlstudies.com/2022/07/21/ssms-put-pinned-tabs-in-their-own-row/