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.
SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
Look before you delete. This SQL in Sixty Seconds video shows one script to select duplicate records and another to delete them while keeping the latest row.
.png)
SQL SERVER – Select the Most Optimal Backup Methods for Server
How to pick the optimal backup methods for your server: know the major backup types, choose a recovery model first and decide how much data you can lose.
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.
Uneven Parallelism: Spotting Skewed Threads Behind CXPACKET Waits
Diagnose uneven parallelism by comparing CXPACKET and CXCONSUMER with per-thread row counts in plans and live query profiles.