> 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 S

> 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. [1] https://www.apexsql.com/sql-tools-refactor.aspx https://www.apexsql.com/sql-tools-refactor.aspx