T SQL Querying [Paperback] Ben Gan, Et Al.

Squeeze maximum performance and efciency from every T-SQL query you write or tune. Four leading experts take an indepth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and rening. All code and techniques are fully updated to reect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012 and help you write faster, more efcient T-SQL code. • Move from procedural programming to the language of sets and logic • Master an efcient topdown tuning methodology • Assess algorithmic complexity to predict performance • Compare data aggregation techniques, including new grouping sets • Efciently perform data analysis calculations • Make the most of T-SQL’s optimized bulk import tools • Avoid date/time pitfalls that lead to buggy,

• T-SQL Fundamentals (3rd Edition)
• Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference)
• Exam Ref 70-761 Querying Data with Transact-SQL
• Microsoft SQL Server 2016 Reporting Services, Fifth Edition
• SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach
• Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
• The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
• SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))
• SQL Server 2017 Administration Inside Out
• MCSA SQL Server 2016 Database Development Exam Ref 2-pack: Exam Refs 70-761 and 70-762