A client clicked Browse for more in SSMS and the Network Servers tab was empty. Here is how we narrowed it down and what caused it.
SQL SERVER – Identifying If Database Supports InMemory OLTP Functionality
I had recently received an email about InMemory OLTP Functionality in Email when I was having a vacation with my family in the Australia.
How to Change Fill Factor in SQL Server – Interview Question of the Week #080
It is surprising to see that lots of people do not know that SQL Server Fill Factor 0 (which is the default value when SQL Server is installed) is equal to value as 100.
SQL SERVER – Inspecting Historical CPU Ring Buffer Samples
CPU Usage History helps me establish when a reported problem began. It gives a timeline rather than identifying the responsible query.
SQL SERVER 2016 – Developer Edition Does Not Expire Like Evaluation Edition
Developer Edition is not the 180-day Evaluation Edition. I check the edition before treating a calculated date as an expiration.
SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW
A client database went SUSPECT after a cluster failure and DTC reinstall. The ERRORLOG showed a DTC/KTM in-doubt Transaction with UOW. How we fixed it.
SQL SERVER – Fix Error Msg 13602 working with JSON documents
Working with JSON documents in SQL Server 2016? You can’t use FOR JSON inside an UPDATE statement, and trying gives Msg 13602. Here is how to work around it.