During Comprehensive Database Performance Health Check, we had an issue where lots of active background jobs consuming lots of important resources.
I have received an interesting email from a client of Comprehensive Database Performance Health Check. His question was related to files with IO Issues.
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.
Question: How to Kill Processes Idle for X Hours?
Question: What is the difference between spid, kpid and ecid in sysprocesses?
Earlier this week, I posted an interesting interview question How to Build Three Part Name from Object_ID? – Interview Question of the Week #134. In its response, I have received a very interesting reply from Rin Sitah over here.