How To Write SQL Server Queries Correctly
These videos all talk about the best ways to logically write queries to get the results you're after as quickly as possible. I cover:
* Joins
* Exists
* Subqueries
* Apply (cross and outer)
* IN and NOT IN
* Common Table Expressions
* Views
* Functions
* UNION and UNION ALL
* INTERSECT and EXCEPT
* OR Clauses
And more!