Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
DBCC SQLPERF can report log usage or reset cumulative wait and latch statistics. I separate reporting from resetting the baseline.
Database File Size Shrinks by Itself? Check Auto Shrink
When a database file keeps getting smaller after you set its size, check Auto Shrink first. This post shows why a size you set later isn’t protected, then gives three checks: the database flag, jobs that shrink, and the default trace. It ends with the fix and the reason shrinking costs more than it saves.
How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135
How do you show results of sp_spaceused in a single result? My co-interviewer asked this. I think it is a poor interview question, but here is the answer.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
I can Clear Plan Cache for the current database through database-scoped configuration. I verify the context before considering eviction.
SPID, KPID and ECID in sys.sysprocesses: What They Mean
SPID, KPID and ECID are the three ID columns of sys.sysprocesses: the session, the Windows thread and the part of a parallel query. This post reads them for an idle session and for a query running in parallel, explains why KPID can be negative, and names the DMVs that give the same answers today.
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.