T-SQL Querying

Inside Microsoft® SQL Server® 2008

Itzik Ben-Gan, Lubor Kollar (Autoren)

Buch | Softcover

832 Seiten

2009
Microsoft Press,U.S. (Verlag)
978-0-7356-2603-4 (ISBN)

Infos

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

Autor

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.

Produkt-Details

• Erscheint lt. Verlag: 25.3.2009
• Verlagsort: Redmond
• Sprache: englisch
• Maße: 188 x 230 mm
• Gewicht: 1372 g
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• Themenwelt: Mathematik / Informatik ► Informatik ► Netzwerke
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• ISBN-10: 0-7356-2603-0 / 0735626030
• ISBN-13: 978-0-7356-2603-4 / 9780735626034
• Zustand: Neuware