A WMI invalid class error can sit behind a patch rule failure that looks like a cluster problem. The rule was Not clustered or the cluster service is up and online. Recompiling the WMI MOF files with mofcomp fixed it for my client.
OFFSET FETCH in SQL Server: Get Rows 21 to 30 After ORDER BY
OFFSET FETCH reads a block of rows from the middle of a sorted result. The demo returns rows 21 to 30, builds pages from a page number and measures why deep pages cost more. A seek based alternative reads the same two pages every time.
How to Write in Text File from T-SQL in SQL Server? – Interview Question of the Week #236
Question: How to Write in Text File from T-SQL in SQL Server?
The question above was actually asked in an interview and also was not asked in the same word.
SQL SERVER – Historical PHYSICAL_ONLY Bug and Version Specific Evidence
A historical SQL Server 2017 Bug affected CHECKDB with PHYSICAL_ONLY and clustered columnstore data. One client observed a dump.
Setup Error 0x800F0831: .NET Framework Install Fails During Upgrade
Setup error 0x800F0831 broke an in-place upgrade from SQL Server 2014 to SQL Server 2016. It is the hex form of exit code -2146498511. The CBS log showed store corruption with a missing package, and installing that package fixed the upgrade.
Filtered Statistics: Fixing Estimates for Skewed Data
Use filtered statistics to describe skewed customer values, inspect histograms, and test estimates under literal and parameterized queries.
Setup Error 1639: Invalid Command Line Argument in SQL Server
Setup error 1639 stopped my SQL Server 2019 install with an invalid command line argument message. The real clue was in the log: a component from an earlier incomplete install was still there. Uninstalling it with msiexec fixed the problem.