Use DELETE TOP safely through an ordered CTE, preview oldest rows, apply a supporting index, and remove eligible rows in bounded batches.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
#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.
Turning a Business Question Into a Query: Define the Metric First
Turn a business question into a tested T-SQL metric with explicit time zones, cancellations, returns, and a hand-checked sample.
Preparing Time Series Features in T-SQL: Lags and Rolling Windows
Prepare time series features with LAG, prior-day rolling windows, calendar flags, and gap boundaries that prevent accidental continuity.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.