Creating an availability group failed with Msg 41105: Failed to create the WSFC resource with type ‘SQL Server Availability Group’. Here are ways to fix it.
SQL SERVER – Cannot Shrink Log File 2 (SQLAuthorityDB_log) Because the Logical Log File Located at the End of the File is in Use
Diagnose a cannot shrink log file message with read-only SQL, active VLF checks and log reuse waits. Keep backup protection and size for the workload.
SQL SERVER – Which Settings Change in sp_configure Needs Restart to Take Effect?
Which settings changed in sp_configure need a restart to take effect? You do not need to remember them, because a catalog view added in SQL Server 2008 tells you.
SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed
A client’s second clustered SQL Server instance failed to install: Specified instance via transform is already installed. Here is what I found and the fix.
How to Sort a Varchar Column Storing Integers with Order By? – Interview Question of the Week #206
How do you sort a Varchar column storing integers with Order By when you cannot change the datatype? Here are two simple solutions I shared with a developer.
SQL SERVER – Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH
Does an NVARCHAR column take twice the space of VARCHAR? Yes. I measure the length of VARCHAR and NVARCHAR columns with COL_LENGTH to show it.
Count a Particular Value Across All Columns in SQL Server
To count a particular value across all columns of a table, use a CASE sum, CROSS APPLY with VALUES, UNPIVOT or UNION ALL. This post tests all four on a staff contact table, compares their reads on 200,000 rows, and builds the column list with dynamic SQL.