A reader tried my ColumnStore on InMemory OLTP example and got Msg 10794: CREATE INDEX is not supported with memory optimized tables. Here is the fix.
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.
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 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 – Displaying SQL Agent Jobs Running at a Specific Time
A client’s server froze every morning at the same time. The cause was a background job, so here is a query for displaying SQL Agent Jobs running at a set time.
PowerShell – Script to Listing all Backups Taken with SQL Server
A handy PowerShell script for listing all backups taken for each database on your SQL Server, one I keep on my USB drive for customer visits.