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.
Weighted Averages in T-SQL
Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.
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
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.
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.
SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size
Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647