by Adam Fulton | Sep 26, 2021 | SQL Server
Find Missing Indexes before going into production Find missing indexes the right way! First of all, finding a missing index is not a rocket science. Always find and create missing indexes before you deploy the code to the production environment. DBA’s and...
by Adam Fulton | Sep 25, 2021 | SQL Server
What are users executing using SSMS? During a customer review meeting, one of the DBA asked if there’s a quick way to find out What are users executing using SSMS. Though this information can easily be obtained from SP_Who2 system stored procedure, the DBA wanted to...