T-SQL Querying

T-SQL Querying : Inside Microsoft SQL Server 2008

By (author)  , By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?


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 skillsshow more

Product details

  • Paperback | 832 pages
  • 186 x 226 x 52mm | 1,660.14g
  • Microsoft Press,U.S.
  • Redmond, United States
  • English
  • black & white illustrations, black & white tables, figures
  • 0735626030
  • 9780735626034
  • 313,592

About Itzik Ben-Gan

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.show more