T�tulo: Microsoft Sql Server 2014 Query Tuning & Optimization (DATABASE & ERP - OMG)
Editor: McGraw Hill
Fecha de publicaci�n: 2014
Idioma: Ingl�s
ISBN 10: 0071829423
ISBN 13: 9780071829427
Encuadernaci�n: Paperback
Estado: Very Good

Acerca de

Sinopsis

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Optimize Microsoft SQL Server 2014 queries and applications

Microsoft SQL Server 2014 Query Tuning & Optimization is filled with ready-to-use techniques for creating high-performance queries and applications. The book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. You’ll also get tips for troubleshooting underperforming queries. In-Memory OLTP (Hekaton), a key new feature of SQL Server 2014, is fully covered in this practical guide.

Understand how the query optimizer works
Troubleshoot queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools
Work with query operators for data access, joins, aggregations, parallelism, and updates
Speed up queries and dramatically improve application performance by creating the right indexes
Understand statistics and how to detect and fix cardinality estimation errors
Maximize OLTP query performance using In-Memory OLTP (Hekaton) features, including memory-optimized tables and natively compiled stored procedures
Monitor and promote plan caching and reuse to improve application performance
Improve the performance of data warehouse queries using columnstore indexes
Handle query processor limitations with hints and other methods

Acerca del autor

Benjamin Nevarez is a Microsoft SQL Server MVP and independent consultant with more than 20 years of experience in relational databases. He specializes in SQL Server query tuning and optimization. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections, and SQLBits.

"Sobre este t�tulo" puede pertenecer a otra edici�n de este libro.

Descripci�n de la librer�a

In 2002, World of Books Group was founded on an ethos to do good, protect the planet and support charities by enabling more goods to be reused. Since then, we've grown into to a global company pioneering the circular economy. Today, we drive the circular economy through three re-commerce brands: - Wob: Through Wob, we sell. We provide affordable, preloved books and media to customers all over the world. A book leaves our collection of over seven million titles and begins a new chapter every two seconds, enabling more goods to be reused. - Ziffit: Through Ziffit, we buy. We give people around the world the opportunity to contribute to the circular economy, earn money and protect the planet, by trading their unwanted books and media. - Shopiago: Through Shopiago, we help others. By sharing the technology that has grown World of Books Group into the business it is today, we?re helping charities increase revenue and reduce waste through re-commerce.

Ver la p�gina web de la librer�a

Informaci�n empresarial del vendedor

World of Books Ltd
Mulberry House, Woods Way Trading Estate, Goring-By-Sea, BN12 4QY, United Kingdom

Condiciones de venta y env�o

Condiciones de venta

WorldofBooks.com fully embraces the AbeBooks terms and conditions and we will do
what we can to resolve any issues.

Condiciones de env�o

Orders ship within 2 business days. Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.