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.
Multi-Column Index Key Order: Which Column Goes First
Test index key order with equality, range, and OR predicates, then use seek predicates and logical reads to choose the lead column.
SQL SERVER – Initializing the FallBack Certificate Failed With Error Code: 1, State: 20, Error Number: 0
After a service account password change, SQL Server would not start: Initializing the FallBack certificate failed, error code 1. Here is the fix.
Does Sort Order in Index Column Matters for Performance? – Interview Question of the Week #199
Does the sort order in an index column matter for performance? Yes, in some specific scenarios, and here is an example from a recent Health Check question.