Missing T-SQL Querying Features for Handling NULLs and for Data Analysis

Explore missing T-SQL querying features for handling NULLs and data analysis in this conference talk from PASS Data Community Summit. Delve into ISO/IEC SQL standard features not implemented in SQL Server, focusing on NULL-related functionalities and data analysis techniques like window functions and row pattern recognition. Learn practical workarounds for T-SQL, covering topics such as distinct predicates, index usage, set operators, NULL sorting, scaling, last non-null values, null treatment clauses, unique row numbers, and window functions. Gain insights from expert Itzik Ben-Gan as he demonstrates these concepts with real-world examples and source code.

Introduction
Source Code
Overview
Distinct Predicate
Using the Index
Set operators
Sorting NULLs
Scaling
Last No Null
Null Treatment Clause
Unique Row Numbers
Window Functions
Example