SQL Server 2016 lets you add a Clustered ColumnStore index to InMemory OLTP tables for operational analytics. A teaser of my SQLPASS session, with an example.
SQL SERVER – Unable to Bring SQL Online – DoSQLDataRootApplyACL : Failed to Create Directory Tree at SQLDataRoot
Unable to bring SQL Online on a cluster node? The cluster log showed DoSQLDataRootApplyACL failed to create directory tree at SQLDataRoot. Here is the fix.
SQL SERVER – Unable to Recycle ERRORLOG Using sp_cycle_errorlog
A reader could not recycle ERRORLOG files with sp_cycle_errorlog. The ERRORLOG itself showed the reason. Here is what went wrong and how to fix it.
SQL SERVER – FIX Error: Maintenance plan scheduled but job is not running as per schedule
A maintenance plan was scheduled for 10 PM, but the job was not running as per schedule and showed no history. Here is how I found the cause.
Error: Msg 1904 The statistics on table has 65 columns in key list
SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list. Let us learn how to fix in this blog.
SQL SERVER – FIX Error 5120 – Database is in Read Only Mode After Attaching Files
An attached database showed read-only and SET READ_WRITE failed with OS error 5, Access is denied. Here is how to FIX Error 5120 with file permissions.
SQL SERVER – Database going to Recovery Pending Automatically and Coming Back
A client’s production database kept going into Recovery Pending on its own and coming back. The ERRORLOG showed OS error 32, file in use by another process.