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

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.