Set temporal table retention, check history cleanup settings, and choose a history index that lets old versions leave safely.
How to Find DISTINCT COUNT of Column Rows Without Using Distinct Count Keywords? – Interview Question of the Week #157
Only one of ten candidates solved this: find the DISTINCT COUNT of a column without using those keywords. Here are the traditional answer and the trick.
SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info
SQL Server now runs on Linux too, so I check the host first in health checks. Here is how the DMV sys.dm_os_host_info returns Host Information about the OS.
SQL SERVER – GDPR Features and Operational Responsibilities
GDPR Compliance concerns how an organization processes personal data. Reader questions prompted my series about the database controls that can help.
SQL SERVER – Activity Monitor – Active Expensive Queries
A DBA spotted an extra pane in my Activity Monitor during a health check. Here is where Active Expensive Queries shows up and which SSMS version has it.
SQL SERVER – Performance Observation of TRIM Function
Does the new TRIM function slow your queries like other functions in a WHERE clause do? Here is my performance observation of TRIM function in SQL Server 2017.
SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation
A client saw numbers from an Oracle linked server shown in scientific notation in SQL Server. Here is the query that shows the issue and how to fix it.