How to improve performance so today we are going to see a video about creating converting index to eliminate join and improve query performance.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup
My video on bookmark lookups brought many questions. Here are 7 follow up answers to remove bookmark lookup doubts, starting with STATISTICS IO overhead.
Day Name From Date in SQL Server: DATENAME, FORMAT and More
Finding the day name from date values takes one function, but three methods exist, and they differ on language and speed. This post compares DATENAME, FORMAT and a formula that ignores language and DATEFIRST. It measures all three on a million rows and shows how the session language changes the result.
What is Full Outer Join With Exclusion? – Interview Question of the Week #286
Question: What is Full Outer Join With Exclusion?
Answer: I got this question after reading my earlier blog post about Basic of JOINs.
Temp Tables For Destruction: Why the Counter Stays Near Zero
The Temp Tables For Destruction counter stays flat at zero while Temp Tables Creation Rate moves, and that confuses people. This post explains what each counter counts, reads both from T-SQL, measures a creation loop, and shows that a cached temp table in a procedure moves neither counter.
Column Statistics in SSMS: Update One With the Dialog
You can update column statistics in SSMS from the Properties window of a statistic, but a dialog gives no proof that anything happened. This post lists the steps, then uses T-SQL to prove the update with the modification counter and the sample size. It also shows why a full scan needs a statement of its own.
Dynamic SQL Output Parameter: Pass Values In and Out Safely
A dynamic SQL output parameter lets a statement built at run time hand a value back to the caller. This post shows input, output and input/output parameters with sp_executesql, explains the errors you meet, and measures why parameters beat concatenation: one reusable plan instead of ten, and no injection.
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.