Here are 3 ChatGPT tricks to tune SQL Server: quick, practical methods to optimize your queries, with a SQL in Sixty Seconds video.
Majoring in the Minors in SQL Server Performance Tuning
We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors.
EXISTS vs IN vs JOIN: Writing Semi-Joins
Compare EXISTS, IN, and JOIN for semi-joins, prevent duplicate customer rows, and handle NULL safely in exclusion queries.
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.
#TSQL2sday Invitation: Has AI Helped You with Your SQL Server Job?
I’m thrilled to be your host for this month’s episode – Has AI Helped You with Your SQL Server Job? schedule it for next Tuesday, April 9.