Is there any difference between LEFT JOIN and LEFT OUTER JOIN? A reader asked, and here is the short answer: none at all, they are the same.
Star Schema Queries and How SQL Server Runs Them
Star schema queries join a large fact table to focused dimensions; learn bitmap filters, columnstore, and indexes that support the real workload.
SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9
Self Join is handy, but it is not allowed in indexed view definitions. Limitation of the view 9 reuses my employee and manager example to show it.
SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8
Why is an outer join not allowed in indexed views? Rows can logically disappear when you insert into a base table. Limitation of the view 8 shows an example.
Tagging With a Many-to-Many Table: Storing and Querying Hashtags
Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.
CROSS APPLY Aggregate: An Empty Input Can Still Return a Row
CROSS APPLY aggregate behavior depends on whether the right-side query actually produces a row. I inspect that query before assuming unmatched customers disappear. An aggregate without GROUP BY can return a row even when its input is empty.
Relational Division in T-SQL: Customers Who Bought Every Product
Solve relational division with counts and double NOT EXISTS, then handle duplicates, NULL values, empty requirements, and exact matching.