Inspect columnstore rowgroup health, understand small and deleted groups, and choose reorganize or rebuild from measured evidence.
SQL SERVER – Get List of the Logical and Physical Name of the Files in the Entire Database
During a Health Check we needed the logical and physical name of every file in every database on the instance. Here is the script I built, with the file type too.
How to Trim TIME Part in DATETIME Values? – Interview Question of the Week #200
How to trim TIME part in DATETIME values? A reader wanted to keep only the date and the hour, so here are ways to cut off the minutes and seconds.
SQL SERVER – Optimize Key Lookup by Creating Index with Include Columns
A query slowed to over 10 minutes because of a big key lookup. Here is how I optimize key lookup operations by creating an index with include columns.
Puzzle – Datatime to DateTime2 Conversation in SQL Server 2017
At PASS, SQL Server expert Christopher Savage showed me a puzzle on DateTime to DateTime2 conversion in SQL Server 2017. I still have no answer, so can you solve it?
SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance
Moving to a new VLAN? These are the exact steps to change the IP addresses of the Windows cluster nodes and of a SQL Server failover cluster instance.
Video – Bert & Pinal Troubleshoot a Slow Performing SQL Server
At my 10th PASS Summit, Bert Wagner and I recorded a video on how to troubleshoot a slow performing SQL Server. Here it is, with a little of the story behind it.