Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.
Setup Error 0x86D80018: No More Endpoints Available From the Endpoint Mapper
Setup error 0x86D80018 stopped a SQL Server 2016 to 2017 cluster upgrade when the client patched the second node. The Next Step in the setup summary named an uninstall command. Running it, then rebooting both nodes, let setup finish.
Batch Requests and Compilations per Second From T-SQL
Calculate compilations per second from cumulative SQL Server counters, compare batch rates, and investigate single-use plans with context.
Msg 3254: The Volume on Device Is Empty During RESTORE
Msg 3254 says the volume on a device is empty, followed by Msg 3013, RESTORE DATABASE is terminating abnormally. A client’s DBA hit it during a restore. In my lab, a text file passed off as a backup gave the same error, and the file size told the story.
Error 9002: Transaction Log Full Due to REPLICATION
A transaction log full due to REPLICATION put error 9002 in a client’s ERRORLOG. The database showed no replication at all. The cause was a leftover publication with no subscriber, and here is how we cleared it and shrank the log.
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
Capturing the SQL Behind SSMS Reports With Extended Events
Capture the SQL behind SSMS reports with a filtered Extended Events ring buffer, inspect batch text, and remove the session afterward.