Itzik Ben-Gan discusses lesser-known T-SQL features and some aspects that many of us make assumptions about.
Category: T-SQL
Itzik Ben-Gan adds another post to his series on T-SQL pitfalls and best practices series, treating complications and limitations of the PIVOT and UNPIVOT operators.
Itzik Ben-Gan continues a pitfall and best practices series with a post explaining how window functions can go wrong in SQL Server.
Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
Aaron Bertrand shares his slide decks and demos from two recent presentations at CodeStock in Knoxville, TN.
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
Paul White explains why the IGNORE_DUP_KEY index option on a clustered index can result in much poorer performance than for a nonclustered unique index.
Rob Farley talks about filtered indexes and when you might want to add filtered columns to the index definition.
Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.
Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.
