How do you deal with the complete lack of searching for tables/SPs/functions in SSMS? There are a number of 3rd party extensions but they all seem slow and still just jump you to the entity in the explorer.
The speed of searching for anything in DataGrip is just so beautiful and amazing for productivity. A big downside is we have run into situations where a SP is cached and is an old version and DataGrip doesn’t notify me that’s the case.
> How do you deal with the complete lack of searching for tables/SPs/functions in SSMS?
That is a weakness of SSMS, and I've no good answers.
For stuff like SQL formatting though, the free ApexSQL Refactor [1] has been a godsend for me. I write a lot of complex analytic queries and having the ability to tidy up statements as I'm writing the query is amazing.
GUI search is awful, but it does exist. Right clicking on an object type node (e.g. 'Tables' or 'Procedures' in the object explorer) and selecting the 'Filter' option gives you a limited search feature for objects in that node.
It is clumsy and painful, and I will most often just query the sys schema to search for objects, but GUI search is there.
The speed of searching for anything in DataGrip is just so beautiful and amazing for productivity. A big downside is we have run into situations where a SP is cached and is an old version and DataGrip doesn’t notify me that’s the case.