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.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203
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.
Optimizer Timeouts: Reason for Early Termination in a Plan
Diagnose optimizer early termination in SQL Server plans, find cached timeouts with XML, and simplify queries using measured evidence.