This is related to a discussion I’ve had with some colleagues during an XE session couple of weeks ago. These are the assumptions you can made: Lock:Deadlock Chain event is produced in the context of the lock monitor’s session. It tends...

Someone asked me that question some weeks ago. Back in 2005 you were able to enable/disable CLR integration from SAC’s GUI (SAC being Surface Area Configuration). Of course you could do it programmatically via sp_configure or via Microsoft.SqlServer...

I just noticed that given the way SQL Server parser parses the CREATE CERTIFICATE statement, the order in which you specify START_DATE & EXPIRY_DATE clauses really matters. If you specify the EXPIRY_DATE clause first, whatever value you specify...

Somebody recently asked me the following: “I’ve been told that when a hashed page from the BPool changes it is not immediately written to the data file on disk. Only the operations that caused that modification to the page are guaranteed to...