Opening tempdb properties in SSMS gave ‘Property Size is not available for Database’. The usual owner fix does not work on tempdb. Here is what did.
SQL SERVER – Unable to Attach Database – File Activation Failure – The Log Cannot be Rebuilt
A client lost the log drive and tried ATTACH_REBUILD_LOG, only to get a file activation failure: the log cannot be rebuilt. Here is why and what they could do.
SQL SERVER – Creating Clustered ColumnStore with InMemory OLTP Tables – Operational Analytics
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.
Performance Comparison EXCEPT vs NOT IN – Interview Question of the Week #095
EXCEPT vs NOT IN: which is faster? An attendee at PASS Summit asked me, and my simple example shows they work the same way and perform the same.
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.