if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences.
SQL SERVER – List All Active Background Jobs
During Comprehensive Database Performance Health Check, we had an issue where lots of active background jobs consuming lots of important resources.
SQL SERVER – Identify Database File with Maximum IO Issues
I have received an interesting email from a client of Comprehensive Database Performance Health Check. His question was related to files with IO Issues.
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.sysschobjs’ With Unique Index ‘clst’.
Learn how to fix: Cannot insert a duplicate key row in object ‘sys.sysschobjs’ with unique index ‘clst’ while using DBCC CLONEDATABASE.
How to Kill Processes Idle for X Hours? – Interview Question of the Week #152
Question: How to Kill Processes Idle for X Hours?
SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses
Question: What is the difference between spid, kpid and ecid in sysprocesses?