Inside Microsoft® SQL Server™ 2005: T-SQL Querying

Inside Microsoft® SQL Server™ 2005: T-SQL Querying
Published:March 29, 2006Language:English
Author:Itzik Ben-Gan (Solid Quality Learning), Lubor Kollar, Dejan SarkaTechnology:Microsoft SQL Server 2005
Length:640 PagesISBN 13:9780735623132

List Price:

$ 44.99
About The BookGet the in-depth architectural insights you need to exploit advanced T-SQL querying techniques.

Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

  • Understand logical and physical query processing

  • Apply a methodology to optimize query tuning

  • Solve relational division problems

  • Use CTEs and ranking functions to simplify and optimize solutions

  • Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors

  • Use the TOP option in a query to modify data

  • Query specialized data structures with recursive logic, materialized path, or nested sets solutions

  • PLUS—Improve your logic and get to the heart of querying problems with logic puzzles


  • Get code and database samples on the Web
    About Itzik Ben-Gan (Solid Quality Learning), Lubor Kollar, Dejan SarkaItzik Ben-Gan is a principal mentor and a founder of Solid Quality Learning. 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.

    Lubor Kollar is the group program manager for SQL Server at Microsoft. His team led the development of key enhancements to the relational engine and T-SQL query capabilities in SQL Server 2005.

    Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Learning, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

    Kalen Delaney, Series Editor, is a principal mentor and a founder of Solid Quality Learning and the author of Inside Microsoft SQL Server 2000.
    Other Books By Itzik Ben-GanOther Books By Lubor KollarOther Books By Dejan Sarka
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book?Your feedback is important in helping us create books that serve your needs and meet your expectations. Please take our survey at www.microsoft.com/learning/booksurvey

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey. The ISBN 13 can be found above.
    To report or search for corrections in this book or companion content,
    please go to www.microsoft.com/learning/support/books/