Distinguish ROWS_PER_BATCH estimates from BULK INSERT commit batches, then review logging, locks, rejected rows, and atomic loading.
Logging Agent Jobs That Call Stored Procedures
Improve logging Agent jobs with procedure run records, start and end events, captured errors, step output, and history correlation.
Cleaning Currency Strings Into decimal Values
Convert currency strings into decimal amounts using known symbols, explicit parsing cultures, conversion checks, and rejection evidence.
A Walkthrough – DATETRUNC Function in SQL Server
One such tool is the DATETRUNC function, introduced in SQL Server 2022. Let’s take a journey to understand how this function can simplify date handling.
DELETE TOP With ORDER BY: Removing the Oldest Rows First
Use DELETE TOP safely through an ordered CTE, preview oldest rows, apply a supporting index, and remove eligible rows in bounded batches.
#TSQL2sday Roundup: Has AI Helped You with Your SQL Server Job?
Earlier, I hosted a TSQL2sDay on Has AI Helped You with Your SQL Server Job?. I had lots of fun reading various contributions.
#TSQL2sday: AI-Assisted Query Optimization in SQL Server
For this month’s T-SQL Tuesday, I share my experience with AI-assisted query optimization: a generative AI tool suggested two alternatives to my query.