Puzzle with UNION Part 4 is for readers who want to think: three queries using UNION, a subquery and NOT EQUAL TO return the same result. Compare their plans.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Simple Puzzle with UNION Part 3
Simple Puzzle with UNION Part 3 has three T-SQL scripts on the UNION clause, and only one is correct. Can you spot it without running them in Management Studio?
How to Check What SQL Server Licensing You Are Actually Using
Check SQL Server licensing evidence with edition and CPU queries, then reconcile visible processors with host inventory and your agreement.
Soft Delete With an IsDeleted Column: Indexes, Views and Keys
Design soft delete with an IsDeleted flag, filtered unique keys and indexes, a live-row view, and a measured archive process.
SQL SERVER – Simple Puzzle with UNION – Part 2
Another back to basics puzzle with UNION: run three queries using UNION ALL, ORDER BY and DISTINCT, then compare their execution plans.
SQL SERVER – Simple Puzzle with UNION
Try this simple puzzle with UNION and ORDER BY. Guess what each of the three queries returns, and see why one of them fails with Msg 108 and Msg 104.
Overlapping Chunks: Splitting Long Text With GENERATE_SERIES
Split long text into overlapping pieces with one short query. Plus the quiet traps: NULL text, a step that is too big, and chopped words.
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.