T-SQL Querying: Inside Microsoft SQL Server 2008

T-SQL Querying: Inside Microsoft SQL Server 2008


By (author) Itzik Ben-Gan, By (author) Lubor Kollar, By (author) Dejan Sarka

List price $48.10
You save $5.20 10% off

Free delivery worldwide
Dispatched in 11 business days
When will my order arrive?

  • Publisher: Microsoft Press,U.S.
  • Format: Paperback | 832 pages
  • Dimensions: 186mm x 226mm x 52mm | 1,660g
  • Publication date: 4 April 2009
  • Publication City/Country: Redmond
  • ISBN 10: 0735626030
  • ISBN 13: 9780735626034
  • Edition: 1
  • Illustrations note: black & white illustrations, black & white tables, figures
  • Sales rank: 242,050

Product description

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

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11

Author information

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.