[Replay] Show 11 – T-SQL




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show011.mp3">Download Episode (mp3)</a> Guy is currently having fun in Thailand, so we don't have a new show this week. Instead, we republish one of our earlier episodes, where we talk about our favorite language - T-SQL. We'll be back with a new show in two weeks. 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: * <a href="http://www.dbnewsfeed.com/2013/03/20/the-axis-of-evil/" target="_blank">Matan Yungman - The Axis of Evil</a> * <a href="https://www.youtube.com/watch?v=-m426WYclz8" target="_blank">Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part1)</a> * <a href="https://www.youtube.com/watch?v=goyWzAu-AA0" target="_blank">Itzik Ben-Gan - Creative Uses of the APPLY Operator (Part2)</a>