• Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions See large image

    Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Paperback) By (author) Itzik Ben-Gan

    Hard to find title available from Book Depository

    $23.87 - Save $13.25 35% off - RRP $37.12 Free delivery worldwide Available
    Dispatched in 3 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    DescriptionApply powerful window functions in T-SQL-and increase the performance and speed of your queries Optimize your queries-and obtain simple and elegant solutions to a variety of problems-using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you're a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Discover how to: * Go beyond traditional query approaches to express set calculations more efficiently * Delve into ordered set functions such as rank, distribution, and offset * Implement hypothetical set and inverse distribution functions in standard SQL * Use strategies for improving sequencing, paging, filtering, and pivoting * Increase query speed using partitioning, ordering, and coverage indexing * Apply new optimization iterators such as Window Spool * Handle common issues such as running totals, intervals, medians, and gaps


Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10

 

Reviews | Bibliographic data
  • Full bibliographic data for Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

    Title
    Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
    Authors and contributors
    By (author) Itzik Ben-Gan
    Physical properties
    Format: Paperback
    Number of pages: 244
    Width: 185 mm
    Height: 226 mm
    Thickness: 18 mm
    Weight: 386 g
    Language
    English
    ISBN
    ISBN 13: 9780735658363
    ISBN 10: 0735658366
    Classifications

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 05
    B&T Modifier: Text Format: 01
    B&T General Subject: 227
    B&T Merchandise Category: COM
    LC subject heading:
    Ingram Subject Code: XL
    Libri: I-XL
    Warengruppen-Systematik des deutschen Buchhandels: 16360
    BIC subject category V2: UMT
    LC subject heading:
    BIC subject category V2: UNSJ
    B&T Approval Code: A93905500, A93603281
    BISAC V2.8: COM051170
    DC22: 005.756
    BISAC V2.8: COM021030
    DC22: 005.2/768
    DC23: 005.7585
    LC classification: QA76.9.C55 B4573 2012
    Ingram Theme: ASPT/SCITAS
    Thema V1.0: UNS, UMT
    Edition statement
    New ed.
    Publisher
    Microsoft Press,U.S.
    Imprint name
    Microsoft Press,U.S.
    Publication date
    04 May 2012
    Publication City/Country
    Redmond
    Author Information
    Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.
    Table of contents
    * Foreword * Introduction * Chapter 1: SQL Windowing * Chapter 2: A Detailed Look at Window Functions * Chapter 3: Ordered Set Functions * Chapter 4: Optimization of Window Functions * Chapter 5: T-SQL Solutions Using Window Functions