Microsoft SQL Server 2014 Query Tuning & Optimization (Paperback)

Benjamin Nevarez

  • 出版商: McGraw-Hill Education
  • 出版日期: 2014-10-07
  • 定價: $1,700
  • 售價: 8.0$1,360
  • 語言: 英文
  • 頁數: 416
  • 裝訂: Paperback
  • ISBN: 0071829423
  • ISBN-13: 9780071829427
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

《Microsoft SQL Server 2014 查詢調整與優化》充滿了可立即使用的技巧,用於創建高效能的查詢和應用程式。本書描述了查詢處理器的內部運作,讓您能夠撰寫更好的查詢並提供查詢處理器所需的高品質資訊,以產生高效的執行計劃。您還將獲得針對效能不佳的查詢進行故障排除的技巧。SQL Server 2014 的關鍵新功能 In-Memory OLTP (Hekaton) 在本實用指南中得到了全面介紹。

本書的內容包括:
- 瞭解查詢優化器的運作方式
- 使用擴展事件、SQL 追蹤、動態管理視圖 (DMV)、資料收集器和其他工具進行查詢故障排除
- 使用查詢運算子進行資料存取、連接、聚合、並行處理和更新
- 通過創建正確的索引來加快查詢速度,大幅提升應用程式效能
- 瞭解統計資訊,並檢測和修復基數估算錯誤
- 使用 In-Memory OLTP (Hekaton) 功能(包括內存優化表和本機編譯的存儲過程)來最大化 OLTP 查詢效能
- 監控和促進計劃緩存和重用,以提升應用程式效能
- 使用列存儲索引來改善數據倉庫查詢的效能
- 通過提示和其他方法處理查詢處理器的限制

這本書將幫助您優化 Microsoft SQL Server 2014 的查詢和應用程式,提升效能並解決常見問題。