Auto update statistics can miss important data patterns; inspect thresholds, ascending keys, sampling, and targeted update schedules.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
CONCAT: Missing Inputs Produce Present Text
CONCAT builds display text from available inputs. Preserve missing-source flags when output alone cannot prove completeness.
Unpivoting Columns Into Rows With CROSS APPLY and VALUES
Use CROSS APPLY and VALUES for unpivoting columns, retain nulls deliberately, preserve labels, and turn paired fields into aligned rows.
WITHOUT_ARRAY_WRAPPER: Keep JSON Cardinality Explicit
WITHOUT_ARRAY_WRAPPER needs a single-row JSON contract. Compare one object with two unwrapped objects and validate the complete generated text.
Finding the One Row That Broke Your Data Load
Trace a data load error to its source row with raw staging, TRY_CONVERT, stable row identifiers, and a rejection report that supports a safe retry.
SQL SERVER – DBA or DBD? – Database Administrator or Database Developer
My poll asked if you are a Database Administrator or Database Developer. Of 694 voters, 63.4% chose developer, so maybe DBD earns a dictionary spot.
SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists
If LEFT JOIN does the same work, the puzzle is why RIGHT JOIN exists at all. Can you show a case where it is truly required? Share your answer.
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.