Microsoft Sql Server 2014 Query Tuning & Optimization (DATABASE & ERP - OMG)
Language: English
Published by McGraw Hill, 2014
- Softcover
- Used
Seller: WorldofBooks, Goring-By-Sea, WS, United KingdomWorldofBooks
AbeBooks seller since March 16, 2007
Condition: Used - Fine
US$ 3.80
Quantity: 1 available
Add to basketSeller Inventory # GOR012887398
- Title
- Microsoft Sql Server 2014 Query Tuning & Optimization (DATABASE & ERP - OMG)
- Author
- Nevarez, Benjamin
- Publisher
- McGraw Hill
- Publication year
- 2014
- Condition
- Fine
- Binding
- Paperback
- Language
- English
- ISBN 10
- 0071829423
- ISBN 13
- 9780071829427
- Item weight
- 680 grams
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
"Synopsis" may belong to another edition of this title.
About the Author
"About the title" may belong to another edition of this title.
WorldofBooks
Goring-By-Sea, WS, United Kingdom
AbeBooks seller since March 16, 2007
Shipping rates from United Kingdom to U.S.A.
| Item | 7 to 12 business days | 5 to 9 business days |
|---|---|---|
| First item | US$ 7.40 | US$ 15.85 |
Payment methods
Store description
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.…
Specialty
COOKERY, RECYCLE, CHARITY, USED BOOKS, MODERN, HISTORY, CHILDRENS, FICTION, CHEAP BOOKS, NON -FICTIONSeller's business information
World of Books Ltd
Mulberry House, Woods Way Trading Estate
Goring-By-Sea, United Kingdom BN12 4QY
Terms of sale
WorldofBooks.com fully embraces the AbeBooks terms and conditions and we will do
what we can to resolve any issues.
Shipping terms
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.