Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.
Disable Query Store on an Always On Database: What Blocks It
To disable Query Store on an Always On database, run ALTER DATABASE with QUERY_STORE = OFF, and try OFF (FORCED) when the statement waits. This post shows the states to read, the background commands that block the statement and the steps used on an Always On database. It marks which parts were tested on a single server and which come from a client case.
How to Check Database Performance Facets in SQL Server? – Interview Question of the Week #270
Question: How to Check Database Performance Facets in SQL Server?
It is very simple to find out the facets of SQL Server Just follow the diagrams listed.
Weighted Averages in T-SQL
Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.
SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper
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.
SQL SERVER – Msg 3254 – The Volume on Device Path\File is Empty. RESTORE DATABASE is Terminating Abnormally
Let us fix today – Msg 3254 The volume on device