Want to store results of query to file automatically without SSMS? Here is how to do it with sqlcmd and its -o option, step by step.
SQL SERVER – Simple Puzzle with UNION Part 5
In Puzzle with UNION Part 5, the final part, two almost identical queries return the same answer, yet their execution plans are very different. Why?
SQL SERVER – Simple Puzzle with UNION Part 4
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 – 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.