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 topicsReseña del editor:
Updating both Inside Microsoft SQL Server 2008 T-SQL Querying (Microsoft Press, 2009) and parts of Inside Microsoft SQL Server 2008 T-SQL Programming (Microsoft Press, 2009), the book gives database developers and administrators a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. Tackle the toughest set-based querying and query tuning problems-guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals-and gain practical approaches and advanced techniques to optimize your code's performance. The book covers many unique techniques that were developed, improved, and polished by the authors over many years of experience, providing highly efficient solutions for common challenges. There's a deep focus on the performance and efficiency of the techniques and solutions that are covered. The book emphasizes correct understanding of the language and its underlying mathematical foundations.
„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.
Buchbeschreibung Microsoft Press Mrz 2015, 2015. Taschenbuch. Buchzustand: Neu. 226x184x45 mm. Neuware - This book gives students a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. Readers will tackle the toughest set-based querying and query tuning problems-guided by an author team with in-depth, inside knowledge of T-SQL. This book deepens student understanding of architecture and internals-and gives practical approaches and advanced techniques to optimize code performance. The book covers many unique techniques that provide highly efficient solutions for common challenges. 836 pp. Englisch. Artikel-Nr. 9780735685048