Microsoft SQL Server 2014 Query Tuning and Optimization
Language: English
Published by McGraw-Hill Education - Europe, 2014
- Softcover
- Used
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.World of Books (was SecondSale)
AbeBooks seller since December 20, 2007
Condition: Used - Very good
US$ 7.47
Quantity: 2 available
Add to basketItem description from seller
Filled with field-tested techniques for optimizing SQL Server 2014 databases, applications, and data warehouses for speed and performanceplus advanced troubleshooting tips for dealing with existing queries that are underperforming.
Seller Inventory # 00096384052
- Title
- Microsoft SQL Server 2014 Query Tuning and Optimization
- Author
- Benjamin Nevarez
- Publisher
- McGraw-Hill Education - Europe
- Publication year
- 2014
- Condition
- Very Good
- Binding
- Paperback
- Language
- English
- ISBN 10
- 0071829423
- ISBN 13
- 9780071829427
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.
World of Books (was SecondSale)
Montgomery, IL, U.S.A.
AbeBooks seller since December 20, 2007
Shipping rates within U.S.A.
| Item | 4 to 12 business days | 3 to 6 business days |
|---|---|---|
| First item | US$ 0.00 | US$ 10.95 |
Payment methods
Store description
Founded in 2002, World of Books is a leading online destination for buying and selling both preloved and new books, committed to making sustainable reading accessible to all. With a mission to help people read more and waste less, World of Books offers a huge range of affordable, high-quality books — giving both new and preloved titles a second life. The company also operates World of Books – Sell Your Books, an easy-to-use platform that allows customers to trade in unwanted books for cash, helping to keep books in circulation while promoting sustainability. As a Certified B Corp, World of Books is driven by a vision to become the world’s largest and most sustainable dedicated online bookstore. The company measures its success through the positive environmental impact it creates, the value it provides to customers, and its ability to operate profitably while supporting its sustainable mission …
Seller's business information
SBYB, Inc.
900 Knell Rd
Montgomery, IL U.S.A. 60538
Terms of sale
We guarantee the condition of every book as it's described on the Abebooks web sites. If you're dissatisfied with your purchase (Incorrect Book/Not as Described/Damaged) or if the order hasn't arrived, you're eligible for a refund within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days.
Shipping terms
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.