T-SQL Querying

ISBN-13: 9780735685048 / Angielski / Miękka / 2015 / 864 str.

Itzik Ben-Gan; Adam Machanic; Dejan Sarka

Opis

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

About This Book

• For experienced T-SQL practitioners
• Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming
• Valuable to developers, DBAs, BI professionals, and data scientists
• Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics

"

O autorze

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.Grega Jerkic is an independent consultant and trainer for SolidQ. For the last 12 years, he has been developing, architecting, and managing projects focusing on data warehousing, MDM, data integration, analytical/planning solutions and predictive analytics--primarily using Microsoft technology. He invented and was lead architect for a predefined business intelligence solution on top of ERP Microsoft Dynamics NAV BI4Dynamics, which is now used worldwide by more than 150 clients and has earned two Microsoft awards for best business intelligence solution for the CEE region. Grega currently provides training and mentoring for the Microsoft BI platform around the world (Microsoft FastTrack DW workshops, Enterprise ETL with SQL 2005/2008, MDX, Advanced PowerPivot, Microsoft SQL 2008 R2 technical workshops, etc). Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.