Not so long ago SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, XML data type, EXCEPT, INTERSECT to name a few. For different reasons some DBA/Developers do not utilize those. In this session I demonstrate different practical use cases where these features could make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize latest T-SQL function over conventional method with the same functionality. I’ll cover in deeps live scenarios where those features won performance efficiency, code readability and other advantages to use them within the stored procedures, functions, triggers and views.
Currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is with the latest Microsoft technologies
Alex has more than 20 years IT experience and currently working in the Pennsylvania branch of Cox Automotive, headquartered in Atlanta, GA. His primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS, SSIS. He provides tuning, optimization, analysis and development service creating new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and one site training. He has worked for the CSC, VerticalNet, IDP, LSAC, TMNAS to name a few and Alex is Data architect at HexaArt Inc. He provides consulting service from NYC, Philadelphia to Delaware. Alex published articles for SQLServerCentral.com and Simple-Talk. Author “XML and JSON Recipes for SQL Server” published by Apress.