Translate CONNECT BY into recursive CTEs with root selection, depth, paths, sibling ordering, cycle checks, and a recursion limit.
SQL SERVER – Solution Part 2 – A Quick Puzzle on SQL JOIN and NULL – SQL Brain Teaser
Part 2 of the solution to my puzzle on SQL Join and NULL. Readers still email me answers every day, so here are more of the good ones they sent.
Numbers Table vs GENERATE_SERIES: Building Rows on Demand
Learn numbers table in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.
What Is Big Data? A Simple Explanation for Database People
What Is Big Data? It is the point where data outgrows one machine, and the fix is to scale out. This post explains the failures of one server and walks through 40 TB split across 8 nodes.
Reading Fixed-Width Text Files With OPENROWSET and a Format File
Read fixed-width text files with OPENROWSET and an XML format file, trim fields, validate conversions, and load only acceptable rows.
Resetting a Test Database With Database Snapshots
Resetting a test database with SQL Server snapshots gives a fast baseline for repeatable tests; create, revert, and manage sparse files safely.
SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser
The solution to my quick puzzle on JOIN and NULL. Many readers said the puzzle had an error; it did not, and here is the answer that works.
SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser
A relaxing SQL Brain Teaser on INNER JOIN and NULL: set up a sample table, look at the result, and fill in the missing T-SQL that produces it.










