How do you find outdated statistics? The honest answer is that ‘outdated’ is subjective. I explain why, and how I look at statistics instead.
SQL SERVER – Network Servers List is Empty in SQL Server Management Studio
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 – Install Error – Could not Find the Database Engine Startup Handle
Install error: Could not find the Database Engine startup handle. This error has many causes, and here is one I found while helping a client.
SQL SERVER – Delayed Durability, or The Story of How to Speed Up Autotests From 11 to 2.5 Minutes
My friend Sergey Syrovatchenko shares how Delayed Durability helped speed up autotests from 11 to 2.5 minutes on a SQL Server 2014 project.
What Breaks If I Drop This Column? sys.sql_expression_dependencies
Use sql_expression_dependencies and referencing-entity queries before a column change, then check module text and external callers for gaps.
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.