Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
20 used & new from £20.20
Have one to sell? Sell yours here
 
   
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)
 
 
Share your own customer images
Search inside this book

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) (Paperback)

by Lubor Kollar, Dejan Sarka Itzik Ben-Gan (Solid Quality Learning) (Author)
4.8 out of 5 stars See all reviews (10 customer reviews)
RRP: £35.49
Price: £23.07 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £12.42 (35%)
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
Usually dispatched within 1 to 3 weeks.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

13 new from £20.85 7 used from £20.20

Frequently Bought Together

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) + Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning) + Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization
Price For All Three: £71.81

Some of these items ship sooner than the others. Show details

Customers Who Bought This Item Also Bought

Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)

by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning)
5.0 out of 5 stars (2)  £23.07
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney
4.0 out of 5 stars (1)  £25.67
Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning)

by Kalen Delaney (Solid Quality Learning)
4.7 out of 5 stars (3)  £24.84
Microsoft® SQL Server™ 2005 Reporting Services Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server™ 2005 Reporting Services Step by Step (Step by Step (Microsoft))

by Stacia Misner; Hitachi Consulting
3.0 out of 5 stars (1)  £20.79
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft))

by Reed Jacobson; Stacia Misner; Hitachi Consulting
3.7 out of 5 stars (3)  £31.96
› Explore similar items

Product details

Product Description

Product Description
Take a detailed look at the internal architecture of T-SQL—and unveil the power of set-based querying—with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language—solving complex problems with real-world solutions. Discover how to: •Understand logical and physical query processing •Apply a methodology to optimize query tuning •Solve relational division problems •Use CTEs and ranking functions to simplify and optimize solutions •Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors •Use the TOP option in a query to modify data •Query specialized data structures with recursive logic, materialized path, or nested sets solutions •PLUS—Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web 
Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below
(1)
See all 4 tags...

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning)
77% buy the item featured on this page:
Inside Microsoft® SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) 4.8 out of 5 stars (10)
£23.07
Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)
9% buy
Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning) 5.0 out of 5 stars (2)
£23.07
SQL Server 2005 Bible
6% buy
SQL Server 2005 Bible 4.5 out of 5 stars (2)
£20.79
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
4% buy
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes 5.0 out of 5 stars (4)
£7.14
Explore similar items
 

Customer Reviews

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

 
17 of 18 people found the following review helpful:
4.0 out of 5 stars Are you a SQL Server database developer? Buy this book!, 29 Sep 2006
By A. Kay - See all my reviews
(REAL NAME)   
Having been bored stiff by many a technical book in the past I found this a refreshing read. Having developed for a number of years using T-SQL I would say I was more of a parrot-fashion database developer until I read this book. The knowledge imparted is invaluable and I would definitely recommend it. This is a book mainly for SQL Server 2005 but there are many 2000 samples for replicating the functionality.

Whilst it has a number of early chapters focusing on querying fundamentals I would still suggest this book is for people who have some experience of SQL Server 2000\2005 T-SQL and not beginners. As the chapters progress Itzik starts giving examples of common development problems and then solves them. Two that spring to mind are creating server-side data paging or dealing with hierarchies. The chapters on query tuning really are a treasure trove. I have seen many a developer look at a graphical query plan with an "oooh that looks pretty" face without any knowledge as to its meaning. This will give a good foundation explaining why the little pictures change and what all the cool figures mean!

Itzik also goes into detail about the most important T-SQL language changes and when to use them and when not to. He shows the performance implications of each choice and critically explains them for the mere mortals amongst us (including me).

I find myself reading a paragraph, asking myself a question only to find he has answered it in the next paragraph. A well written book on a difficult subject matter. It is clear that Itzik has a passion for SQL Server and set-based logic and this is apparent in the writing style throughout the book making it an easy read (if your a database guy/gal).
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
4 of 4 people found the following review helpful:
5.0 out of 5 stars A great reference, 15 Sep 2006
By Michael Fourie (UK) - See all my reviews
(REAL NAME)   
The book is written in an informal manner and very easy to read. There is quite a lot of SQL 2000 matter within, though in most places it's trumped by the new capabilities of 2005. Like he does in his lectures, he takes you through a lot of scenarios and shows you how to make code faster and faster and faster... I'm glad I bought this book and will definitely be referring back to it (because I forget things!).
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
9 of 11 people found the following review helpful:
5.0 out of 5 stars An Essential Text, 29 May 2006
By James World "Whirly" (Oxfordshire, UK) - See all my reviews
(REAL NAME)   
This book is destined to become a classic. Benefiting from the main author's close relationship with the product team, this text provides a distilled insight into the machinations of SQL Server that are hard to garner from elsewhere. Managing to be both a reference text and a step-by-step tutorial, this book will furnish you with all tools you need to effectively author and tune T-SQL to highest standards. I particularly commend the chapter detailing a tuning methodology.

Having said all this, bewarned that this text is not for the novice or beginner. While it is excellently written, it is an advanced text pitched at those with plenty of prior T-SQL experience, and will require careful study. That being said, for those who put in the effort, the rewards will be plentiful.

My only criticism is that a book on T-SQL this good didn't come sooner. A fanatastic work I will be returning to again and again.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars Very good book regarding SQL
This is a fair thick volume containing a wealth of knowledge regarding SQL server. Much of the work and example are specific to MS SQL Server 2005, but where this is the case it... Read more
Published 10 months ago by M. Barker

5.0 out of 5 stars An excellent well written book
I looked through the reviews of the books with SQL in the title and opted for this one as is had the highest number of 5 star reviews. Read more
Published 16 months ago by Glenn

5.0 out of 5 stars Thorough explanation of SQL language & much more
This book is mainly aimed at programmers, but I purchased it along with a number of other books to better understand what SQL is, and how it can help me to write better queries in... Read more
Published 22 months ago by C. Wheeler

5.0 out of 5 stars Fantastic stuff
I have used SQL for about 20 years and TSQL for about 10 and, although I did not finish the book yet, I am delighted with what I have read so far. Read more
Published on 14 Feb 2007 by Eric Le Bouffon

5.0 out of 5 stars Everyone can learn from this book!
Itzik is an internationally renown lecturer, trainer and writer who anyone familiar with SQL Server will immediately recognise. Read more
Published on 28 Nov 2006 by Martin Bell

5.0 out of 5 stars If you work with SQL 2005 you need this book
This is a great book and provides valuable insight into the workings of SQL Server 2005 and is certainly one to have on the shelf
Published on 9 May 2006 by John Plummer

5.0 out of 5 stars If you want to fully understand the query engine in SQL2005, this is the book for you!
I always wait for the "Inside" series of books, and this time I was once again delighted with the result! Read more
Published on 5 May 2006 by Mark Anderson

Only search this product's reviews


Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   

Listmania!

Create a Listmania! list

Look for similar items by category

Feedback

Health & Beauty at Amazon.co.uk

Elemis Resurface and Renew Skin Care Gift Set of 4 Products
From soap to shavers, massagers to mascara, stock up on your daily essentials or truly pamper yourself.

›Discover Health & Beauty

  

More From Dejan Sarka

MCTS Self-Paced Training...

MCTS Self-Paced Training Kit...

Announcing an all-new Self-Paced Training Kit designed to help... Read more
£55.81 £47.44

 

A Close Shave

Philips Nivea Coolskin HS8060 Moisturizing Rotary Shaving System
For all types of hair removal, stay smooth with Amazon.co.uk.

›Discover Shaving & Hair Removal

  

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

  
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

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

Look to the right column to find helpful suggestions for your shopping session.
Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates