T-SQL Querying: Inside Microsoft SQL Server 2008

T-SQL Querying: Inside Microsoft SQL Server 2008

Paperback

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

$33.91
List price $48.41
You save $14.50 29% off

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

  • Publisher: Microsoft Press,U.S.
  • Format: Paperback | 832 pages
  • Dimensions: 188mm x 226mm x 46mm | 1,565g
  • 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: 198,011

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
Categories:

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.