Show 11 – T-SQL

Did you know that SQL was initially called "Sequel" (Structured English Query Language)? On this show, we go back to basics and talk about our favorite language – Transact-SQL (T-SQL). We cover a lot of topics in the fields of development, performance and maintenance. Among them: The logical phases of query processing Our favorite and least favorite T-SQL features T-SQL development best practices How to avoid writing long Stored Procedures How to avoid writing the "mother of all queries" The Axis of Evil T-SQL featrues Why you should (almost) never use table variables Items mentioned in the show: Matan Yungman – The Axis of Evil Itzik Ben-Gan – Creative Uses of the APPLY Operator (Part1) Itzik Ben-Gan – Creative Uses of the APPLY Operator (Part2)