Is MERGE really slow, or did the rewrite just run on a quiet night? Here is a fair test you can run yourself.
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.
Picking Random Winners Fairly With NEWID and CRYPT_GEN_RANDOM
Pick random winners with NEWID or cryptographic randomness, handle weights and unique entrants, and save a draw with its seed and timestamp.
SQL Server Agent Basics
SQL Server Agent basics covers jobs, steps, schedules, proxies, and history so a first useful job runs with a clear owner and failure path.
Removing Repeated Characters From a String With GENERATE_SERIES
Remove repeated characters with GENERATE_SERIES, ROW_NUMBER, and ordered STRING_AGG, then benchmark a SQL Server 2019 fallback.
A Calendar Table With Holidays for Date Math
Build a calendar table with weekdays, fiscal months, and American holiday flags, then count working days and find useful date boundaries.
SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies
Which tables does a procedure use, and which procedures use a table? sys.sql_expression_dependencies answers both, with referenced and referencing objects.