T-SQL insiders help you tackle your toughest queries and query-tuning problems
Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth 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 refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.
Write faster, more efficient T-SQL code:
• Move from procedural programming to the language of sets and logic
• Master an efficient top-down tuning methodology
• Assess algorithmic complexity to predict performance
• Compare data aggregation techniques, including new grouping sets
• Efficiently perform data-analysis calculations
• Make the most of T-SQL’s optimized bulk import tools
• Avoid date/time pitfalls that lead to buggy, poorly performing code
• Create optimized BI statistical queries without additional software
• Use programmable objects to accelerate queries
• Unlock major performance improvements with In-Memory OLTP
• Master useful and elegant approaches to manipulating graphs
Get code samples at:
About the Authors
Itzik Ben-Gan, SQL Server MVP since 1999, cofounded SolidQ and created its Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses. He leads many T-SQL training events and speaks at TechEd, SQLPASS, and SQL Server Connections.
Dejan Sarka, MCT, SQL Server MVP, is a database/BI consultant, trainer, and developer specializing in data modeling, data mining, and data quality. The author or coauthor of 11 books, he founded the Slovenian SQL Server and .NET Users Group.
Adam Machanic, SQL Server MVP, is a developer, writer, and speaker focused on large-scale data warehouse performance and development. He created the award-winning SQL Server stored procedure sp_WhoIsActive and contributed to several SQL Server books.
Kevin Farlee, Storage Engine Program Manager on the SQL Server team, has 25+ years of database and storage experience.