Interview question: how to kill processes idle for X hours in SQL Server? Here is a script that finds idle sessions and kills them.
SQL SERVER – Difference Between spid, kpid and ecid in sysprocesses
What is the difference between spid, kpid and ecid in sysprocesses? Here is what each of these three columns means, with a simple query to see them.
SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?
Rin Sitah replied to my interview question with a neat alternative way to build three part name from Object_ID using sys.objects and sys.schemas.
How to Build Three Part Name from Object_ID? – Interview Question of the Week #134
If you only have an object_id, can you get the database, schema and object name? Here is a simple script that builds the Three Part Name from Object_ID.
SQL SERVER – sp_readrequest – Long Running Process
sp_readrequest kept showing up as a long running procedure. It is Database Mail waiting on its queue with a 600 second timeout, usually nothing to worry about.
What is a Master Database in SQL Server? – Interview Question of the Week #076
A reader told me he had dropped his master database. So here is the basic question: what is a master database in SQL Server, and why does it matter?
SQL SERVER – System Objects Not Visible in SQL Server Management Studio
Why were system objects not visible in SSMS 2016 when SSMS 2014 showed them on the same instance? A client asked me, and here is the answer.