did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

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 Icon 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.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $49.99 Save up to $11.75
  • Digital
    $38.24
    Add to Cart

    DURATION
    PRICE

Supplemental Materials

What is included with this book?

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.

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 Used, Rental and eBook copies of this book are 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.

Rewards Program