Inside Microsoft® SQL Server® 2008: T-SQL Querying

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

ISBN 10: 0735626030 / ISBN 13: 9780735626034

Verlag: Microsoft Press (edition 1), 2009

Beschreibung

Heavy wear. Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Bestandsnummer des Verkäufers 0735626030-7-1-13

Bibliografische Details

Titel: Inside Microsoft® SQL Server® 2008: T-SQL ...

Verlag: Microsoft Press (edition 1)

Erscheinungsdatum: 2009

Einband: Paperback

Zustand: Fair

Auflage: 1.

Über diesen Titel

Inhaltsangabe:

Book by Itzik BenGan Lubor Kollar Dejan Sarka Steve Kass

Reseña del editor:

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