Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error.
SQL SERVER – Columnstore Index Cannot be Created When Computed Columns Exist
A developer found a columnstore index cannot be created on a large history table in SQL Server 2014. The surprise cause: computed columns in the table.
Duplicate Entry for Key PRIMARY in wp_options: Fix With REPAIR TABLE
A duplicate entry for key PRIMARY on INSERT INTO wp_options made my blog slow and stopped scheduled posts. After four hours of trial and error, REPAIR TABLE wp_options fixed the corrupted table. Here is the log line, the command and a script that repairs every table.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
A customer moving from Oracle kept getting Error 18456, Severity: 14, State: 5 from Java and from SSMS. Here is how we found the real cause.
SQL SERVER – GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key – SQL Server Cluster
In a two-node SQL Server Cluster, SQL would not come online on one node and wrote no ERRORLOG. The cluster log showed GetRegKeyAccessMask. Here is the fix.
SQL SERVER – How to Fix Error 8134 Divide by Zero Error Encountered
Error 8134 means an expression tried to divide by zero. I choose the intended undefined-result behavior before guarding the division.
SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512
SSMS backup failed with ‘Cannot use the backup file because it was originally formatted with sector size 4096’. Here is why it happens and the easy fix.