or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
More Buying Choices
37 used & new from $25.99

Have one to sell? Sell yours here
 
   
Inside Microsoft® SQL Server® 2008: T-SQL Querying
 
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get your Kindle here.
 
  

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

~ (Author), (Author), (Author), Steve Kass (Author)
Key Phrases: table expressions, ranking functions, data modification, Inner Join, Nested Loops, Estimated Number of Rows (more...)
5.0 out of 5 stars  See all reviews (3 customer reviews)

List Price: $49.99
Price: $31.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $18.50 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, November 17? Choose One-Day Shipping at checkout. Details
24 new from $28.03 13 used from $25.99

Frequently Bought Together

Inside Microsoft® SQL Server® 2008: T-SQL Querying + Microsoft® SQL Server® 2008 Internals (Pro - Developer) + Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)
Price For All Three: $100.77

Show availability and shipping details

  • This item: Inside Microsoft® SQL Server® 2008: T-SQL Querying by Itzik Ben-Gan

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Microsoft® SQL Server® 2008 Internals (Pro - Developer) by Kalen Delaney

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer) by Itzik Ben-Gan

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

by Itzik Ben-Gan
4.7 out of 5 stars (12)  $31.49
Inside Microsoft® SQL Server® 2008: T-SQL Programming (Pro-Developer)

Inside Microsoft® SQL Server® 2008: T-SQL Programming (Pro-Developer)

by Itzik Ben-Gan
5.0 out of 5 stars (1)  $31.49
Programming Microsoft SQL Server 2008 (PRO-Developer)

Programming Microsoft SQL Server 2008 (PRO-Developer)

by Andrew J. Brust
4.4 out of 5 stars (5)  $37.79
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)

by Grant Fritchey
4.8 out of 5 stars (8)  $34.64
Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 (PRO-Developer)

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 (PRO-Developer)

by Lynn Langit
4.5 out of 5 stars (2)  $31.49
Explore similar items

Editorial Reviews

Product Description

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

Product Details

  • Paperback: 688 pages
  • Publisher: Microsoft Press; 1 edition (March 25, 2009)
  • Language: English
  • ISBN-10: 0735626030
  • ISBN-13: 978-0735626034
  • Product Dimensions: 8.9 x 7.3 x 2.1 inches
  • Shipping Weight: 3.5 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon.com Sales Rank: #21,127 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #8 in  Books > Computers & Internet > Microsoft > Development > SQL Server
    #13 in  Books > Computers & Internet > Networking > Data in the Enterprise > Client-Server Systems
    #14 in  Books > Computers & Internet > Databases > Database Management Systems

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Inside This Book (learn more)

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

3 Reviews
5 star:
 (3)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (3 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
2 of 2 people found the following review helpful:
5.0 out of 5 stars What else can we ask to have in one book about T-SQL Querying?, July 19, 2009
By Alejandro Mesa (Lake Wylie, SC USA) - See all my reviews
(REAL NAME)   
I have really enjoyed this book from the begining to the end.

The new chapters from Steve and Dejan:

- Set Theory and Predicate Logic
- Algorithms and Complexity
- The Relational Model

are a very good complement. Having these topics is handy and refreshing, not to mention a must in this discipline.

Itzik's cover about the new T-SQL features introduced with SQL Server 2008, is insightful and very well guided. No doubt that he is an educator by nature.

If you are new to T-SQL, I strongly recommend that you first read Itzik's book "Microsoft® SQL Server® 2008 T-SQL Fundamentals", prior to diving into this series (T-SQL Querying and T-SQL Programming).

Thanks to all the authors for such wonderful book.

Alejandro Mesa
SQL Server MVP
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
1 of 1 people found the following review helpful:
5.0 out of 5 stars Very well done, August 23, 2009
By K. Goodhew (Boulder, CO USA) - See all my reviews
(REAL NAME)   
I'm new to T-SQL, but not new to database programming. I found this to be an excellent reference for the advanced programmer. The examples are well thought out and well organized. He often gives several different examples of how to solve a problem along with the pros and cons of each solution.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
3 of 5 people found the following review helpful:
5.0 out of 5 stars Great mentoring book, April 30, 2009
As usual books from Itzik Ben-Gan give me better understanding of hard-to-grasp concept related to set theory and SQL query.
Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
Book's Companion Website (www.insidetsql.com) 0 April 2009
See all discussions...  
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
   



So You'd Like to...


Create a guide

Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.