Inside Microsoft® SQL Server® 2008: T-SQL Querying

Inside Microsoft® SQL Server® 2008: T-SQL Querying
Published:March 25, 2009Language:English
Author:Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass (Solid Quality Mentors)Technology:Microsoft SQL Server 2008
Length:832 PagesISBN 13:9780735626034

List Price:

$ 49.99
About The BookMaster the mechanics behind advanced querying and tuning—for faster, more scalable code

Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.

Discover how to:

  • Move from procedural programming to the language of sets and logic

  • Optimize query tuning with a top-down methodology

  • Assess algorithmic complexity to predict performance

  • Compare data-aggregation techniques, including new grouping sets

  • Manage data modification—insert, delete, update, merge—for performance

  • Write more efficient queries against partitioned tables

  • Work with graphs, trees, hierarchies, and recursive queries

  • Plus—Use pure-logic puzzles to sharpen your problem-solving skills

  • About Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass (Solid Quality Mentors)Itzik Ben-Gan is a mentor and cofounder of Solid Quality Mentors. A Microsoft MVP for SQL Server since 1999, he teaches and consults internationally on T-SQL querying, programming, and query tuning. He's written numerous articles for SQL Server Magazine and MSDN and presented at Microsoft Tech
  • Ed, DevWeek, PASS, and SQL Server Magazine Connections. Lubor Kollar is group program manager with the SQL Server Customer Advisory Team at Microsoft, working on the most challenging SQL Server deployments worldwide. He has 13+ years of experience with SQL Server development. Dejan Sarka, MCT, MCITP, MCDBA, is an MVP for SQL Server who develops database and business intelligence solutions. He is a mentor for Solid Quality Mentors and has presented at Tech
  • Ed, PASS, and SQL Server DevCon. Steve Kass, PhD, is an MVP for SQL Server and a professor of mathematics and computer science. He has written for SQL Server Magazine and spoken at SQL Server Magazine Connections events.
  • 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

    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 its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.