Three questions I get all the time: where to get AdventureWorks, restoring a 64-bit backup on a 32-bit server, and restoring a 2012 database to 2008 or 2005.
SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup – A DBA Conversation
Error 4214 says BACKUP LOG cannot be performed because there is no current database backup. It often shows up right after a switch to the full recovery model.
SQL SERVER – What is Hekaton? – Simple Words Explanation
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.
SQL Bangalore: The First SQL Server User Group Meeting
SQL Bangalore, our new SQL Server user group, held its first meeting on November 24, 2012. We had five 30 minute sessions, a surprise guest from Mumbai and an international guest from the USA. Here is my report, with photographs.










