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

by Dejan Sarka (Author), Dejan Sarka (Author), Itzik Ben-Gan (Author), Lubor Kollar (Author)

• Used

  Paperback
  2006

  $3.33

  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