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.
SQL SERVER – How to Escape a Single Quote in SQL Server?
In my earlier post on “How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192 I showed you a method of escaping a single quote.
AlwaysOn Queries Stuck on HADR_AR_CRITICAL_SECTION_ENTRY Wait
AlwaysOn queries stuck on HADR_AR_CRITICAL_SECTION_ENTRY followed a short loss of cluster quorum at a client site. Every change to the availability group waited. Setting failover to manual and restarting both replicas cleared the wait.
SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed
Configuring an availability group is easy; trouble starts when the cluster breaks. Here I fix a failed cluster resource of type SQL Server Availability Group.