When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing
A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.
SQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016
After a big upgrade, a client’s SQL Server showed high CPU Consumption, and they called me in twice. Here is what we found and the simple fix.
SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List
A service pack failed with: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Here is what I found.
SQL SERVER – Service Pack Error – Attributes do not Match
A service pack error on my lab machine: ‘Attributes do not match’, with the folder shown as Compressed. Here is what Summary.txt said and the fix.
SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types
A service pack install in a cluster failed with: There was an error to lookup cluster resource types. Detail.txt pointed to the cause. Here is the fix.
SQL SERVER – CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016
No more IF EXISTS and DROP before CREATE. SQL Server 2016 Service Pack 1 adds CREATE OR ALTER for stored procedures and other objects.