Find missing indexes and improve query performance

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

What are users executing from SSMS

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

SP_What is smarter than SP_Who2

SP_What is smarter than SP_Who2! We’ve seen many DBAs scratch their head to find out who is running what in SQL Server. When a user complains about the database performance issue, the first thing DBAs do is run SP_Who or SP_Who2 to see what may be happening in SQL...

SQL Agent Job Failure Permanent Fix

SQL Agent Job Repeat Failures SQL Agent job failure can be easy to fix but the problem many production DBA’s encounter is the repeat failures of SQL agent job failures. Identifying that there’s a problem would be your first step to fix the problem...

How to rebuild indexes in SQL Server

We get many requests to help with performance issues. we strongly recommend users to sign up: SELECT sqlschema.name AS 'SchemaName', object_name(sqlfrag.object_id) AS 'TableName', sqlindexes.name AS 'IndexName', sqlfrag.alloc_unit_type_desc AS 'AllocUnitType',...