A follow-up to my post on hash collisions: DMV queries that help with identifying InMemory OLTP Hash Collisions caused by a poorly chosen bucket count.
SQL SERVER – SQL Profiler vs Extended Events
SQL Profiler or Extended Events? I compare how each one works, why SQL Trace adds overhead on a busy server, and why Extended Events is my choice.
Who Changed This Row? Temporal History With FOR SYSTEM_TIME ALL
Read FOR SYSTEM_TIME ALL with LAG to compare row versions, choose temporal window boundaries, and record an actor when identity matters.
SQL SERVER – Maintenance Plan Folder Missing Under Management in SQL Server Management Studio
A reader wanted scheduled backups on SQL Server 2016 but found the Maintenance Plan Folder Missing under Management in SSMS. Here is my answer.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
Can We Have NULL Value in Primary Key? – Interview Question of the Week #075
Can we have a NULL value in primary key columns? No. The primary key has to uniquely identify each row, and NULL cannot do that. Here is why.
SQL SERVER 2016 – How to Use SQL Server 2016 – Stretch Database – Notes from the Field #127
Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while your queries keep working.