Inside Microsoft SQL Server 2008: T-SQL Querying (Paperback)

Itzik Ben-Gan, Lubor Kollar, Dejan Sarka, Steve Kass

  • 出版商: MicroSoft
  • 出版日期: 2009-03-25
  • 售價: $1,650
  • 貴賓價: 9.5$1,568
  • 語言: 英文
  • 頁數: 688
  • 裝訂: Paperback
  • ISBN: 0735626030
  • ISBN-13: 9780735626034
  • 相關分類: MSSQLSQL
  • 其他版本: T-SQL Querying (Paperback)

買這商品的人也買了...

商品描述

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