9780735626034

Inside Microsoft SQL Server 2008 T-SQL Querying

by ; ; ;
  • ISBN13:

    9780735626034

  • ISBN10:

    0735626030

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2009-03-25
  • Publisher: Microsoft Press
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $7.50
  • Buy New
    $42.49
    Add to Cart Free Shipping

    USUALLY SHIPS IN 3-5 BUSINESS DAYS

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

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

Author Biography

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.

Table of Contents

Foreword
Acknowledgments
Introduction
Logical Query Processing
Set Theory and Predicate Logic
The Relational Model
Query Tuning
Algorithms and Complexity
Subqueries, Table Expressions, and Ranking Functions
Joins and Set Operations
Aggregating and Pivoting Data
TOP and APPLY
Data Modification
Querying Partitioned Tables
Graphs, Trees, Hierarchies, and Recursive Queries
Logic Puzzles
About the Authors
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review