Microsoft SQL Server 2014 Query Tuning & Optimization
Language: English
Published by McGraw Hill (edition 1), 2014
- Softcover
- Used
Seller: BooksRun, Philadelphia, PA, U.S.A.BooksRun
AbeBooks seller since February 2, 2016
Condition: Used - Very good
US$ 8.52
Quantity: 1 available
Add to basketItem description from seller
It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting.
Seller Inventory # 0071829423-11-1
- Title
- Microsoft SQL Server 2014 Query Tuning & Optimization
- Author
- Nevarez, Benjamin
- Publisher
- McGraw Hill (edition 1)
- Publication year
- 2014
- Condition
- Very Good
- Binding
- Paperback
- Language
- English
- ISBN 10
- 0071829423
- ISBN 13
- 9780071829427
- Edition
- 1.
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.
BooksRun
Philadelphia, PA, U.S.A.
AbeBooks seller since February 2, 2016
Shipping rates within U.S.A.
| Item | 3 to 8 business days | 3 to 6 business days |
|---|---|---|
| First item | US$ 0.00 | US$ 3.99 |
Payment methods
Store description
BooksRun helps save money on books. Founded in 2014, we are an independent online bookseller with thousands of happy customers and top ratings. With millions of titles in stock, from fiction to textbooks, we have the best book selection and prices 90% below the list price. We ship all orders the same day or the next business day. Expedited shipping arrives in 2 - 5 business days. Returns are accepted within 30 days of delivery. We are committed to providing each customer with the highest standard of customer service. Please carefully check the book’s description and condition before ordering. If you have any questions or issues, please contact us first. Thank you for choosing BooksRun!…
Specialty
Сollege textbooks and trade booksSeller's business information
AZ Texts LLC
228 Park Ave S Suite 38827
New York, NY U.S.A. 10003
Terms of sale
30 days hassle-free returns guaranteed!