Expert T-SQL Window Functions in SQL Server

Kathi Kellenberger

  • 出版商: Apress
  • 出版日期: 2015-03-21
  • 售價: $1,250
  • 貴賓價: 9.5$1,188
  • 語言: 英文
  • 頁數: 152
  • 裝訂: Paperback
  • ISBN: 1484211049
  • ISBN-13: 9781484211045
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions.

First introduced in SQL Server 2005, window functions came into full blossom with SQL Server 2012. They truly are one of the most notable developments in SQL in a decade, and every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Begin using windowing functions like ROW_NUMBER and LAG, and you will discover more ways to use them every day. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, they will be easier to write, and they will be easier to deconstruct and maintain and enhance in the future.

Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server explains clearly how to get the best performance. The book also covers the rare cases when older techniques are the best bet. Stop using cursors and self-joins to solve complicated queries. Become a T-SQL expert by mastering windowing functions.

  • Teaches you how to use all the window functions introduced in 2005 and 2012.
  • Provides real-world examples that you can experiment with in your own database.
  • Explains how to get the best performance when using windowing functions.

商品描述(中文翻譯)

《Expert T-SQL Window Functions in SQL Server》將帶領您從任何程度的窗口函數知識,成為能夠使用這些強大函數解決許多 T-SQL 查詢的專家。透過窗口函數的魔力,取代緩慢的游標和自我連接,撰寫簡單且效能更好的查詢。

窗口函數在 SQL Server 2005 中首次引入,並在 SQL Server 2012 中得到充分發展。它們確實是 SQL 領域十年來最值得注意的發展之一,每位開發人員和資料庫管理員都能從它們的表達能力中受益,解決日常業務問題。開始使用像 ROW_NUMBER 和 LAG 這樣的窗口函數,您將每天發現更多使用它們的方式。您將以不同的方式處理 SQL Server 查詢,思考的是資料集而不是個別行。您的查詢將運行更快,撰寫更容易,並且在未來的維護和增強中更容易解構和改進。

僅僅了解和使用這些函數是不夠的,您還需要了解如何調整查詢以獲得最佳性能。《Expert T-SQL Window Functions in SQL Server》清楚地解釋了如何獲得最佳性能。本書還涵蓋了在某些特殊情況下,舊技術是最佳選擇的情況。停止使用游標和自我連接來解決複雜的查詢。通過精通窗口函數,成為 T-SQL 專家。

本書教您如何使用在 2005 年和 2012 年引入的所有窗口函數。提供了您可以在自己的資料庫中實驗的實際範例。解釋了在使用窗口函數時如何獲得最佳性能。