Creating an AlwaysOn listener failed: the WSFC cluster could not bring the Network Name resource with DNS name online. Why it happens and how to fix it.
Finding Which Indexes Use a Custom Fill Factor Setting
Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.
Work Table Page Could Not Be Moved: DBCC SHRINKFILE on TempDB
A work table page can stop DBCC SHRINKFILE from reaching the size you asked for in tempdb. This post shows tested queries that compare configured and current file sizes, split tempdb space by object type and find the sessions that hold it. The original client case needed a planned restart to reset the file sizes.
SQL SERVER – sp_readrequest – Long Running Process
sp_readrequest kept showing up as a long running procedure. It is Database Mail waiting on its queue with a 600 second timeout, usually nothing to worry about.
How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #115
Want to see How Many Rows Each Query Returned along with its execution plan? Here is a query for it, and why reads and worker time matter more.
SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request
Installing a service pack on a clustered instance failed with EnumeratorException: Failed to retrieve data for this request. Detail.txt showed the cause.
SQL SERVER – Availability Group Missing or Deleted Automatically?
Investigate an availability group missing from SSMS by comparing SQL metadata, replica state and cluster logs before choosing a recovery procedure.