What is Hekaton? In simple words, it is the in-memory feature announced at PASS Summit 2012 that keeps busy tables in memory to make applications much faster.
Disabling Nonclustered Indexes Before a Large Load, Then Rebuilding
Test disabling nonclustered indexes before a large load, rebuilding them afterward, and measuring total time and log use.
MERGE Performance for Large Upserts: UPDATE Then INSERT Instead
Is MERGE really slow, or did the rewrite just run on a quiet night? Here is a fair test you can run yourself.
SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server
Is there a difference between CURRENT_TIMESTAMP and GETDATE()? No. One is ANSI SQL and the other is the T-SQL version, and both return the same value.
Delete Duplicate Records in SQL Server: SQL in Sixty Seconds #036
To delete duplicate records safely, look at them first. The tests here find the duplicates, preview the rows that will go, delete all but the newest copy inside one transaction and add a unique index so they cannot return. Every query ran on SQL Server 2025.
Optimal Backup Methods: Full, Differential and Log Plans Compared
How to pick the optimal backup methods for your server: choose a recovery model first, then compare Full, Differential and Transaction Log backup plans. The chart lists the pros and cons of each.
Writing T-SQL With an AI Assistant: What to Check Before You Run It
Review T-SQL from an AI assistant for real columns, safe writes, index access, date boundaries, isolation, and rollback tests.