| Web Development Books on CSS, Standards, Web Development |
|
|
|
|
| Inside Microsoft SQL Server™ 2005: T-SQL Querying (Solid Quality Learning) | 
 enlarge | Author: Lubor Kollar, Dejan Sarka Itzik Ben-gan (solid Quality Learning)
Publisher: MICROSOFT PRESS
Category: Book
List Price: £30.99
Buy New: £17.42
You Save: £13.57 (44%)
New (44) Used (9) from £11.99
Avg. Customer Rating:  10 reviews
Sales Rank: 6742
Media: Paperback
Number Of Items: 1
Pages: 632
Shipping Weight (lbs): 2.7
Dimensions (in): 8.8 x 6.9 x 1.6
ISBN: 0735623139
Dewey Decimal Number: 005.7565
EAN: 9780735623132
ASIN: 0735623139
Publication Date: April 1, 2006
Availability: Usually dispatched within 1-2 business days
Condition: New, unread, unused and in perfect condition with no missing or damaged pages, may have a remainder mark. Ships from NY, USA. Your item should arrive in 15-30 days from date of shipment based on your location.
|
| Customer Reviews:
| Showing reviews 6-10 of 10 | | « PREV | | |
 Are you a SQL Server database developer? Buy this book! September 29, 2006
16 out of 17 found this review helpful
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).
A great reference September 15, 2006
2 out of 2 found this review helpful
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!).
An Essential Text May 29, 2006
6 out of 8 found this review helpful
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.
If you work with SQL 2005 you need this book May 9, 2006
1 out of 9 found this review helpful
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
If you want to fully understand the query engine in SQL2005, this is the book for you! May 5, 2006
3 out of 5 found this review helpful
I always wait for the "Inside" series of books, and this time I was once again delighted with the result!
This book explains with in-depth detail how the to optimise your T-SQL code and how the SQL Engine interprets your queries helping you to understand how to get the best out of the Microsoft platform. This book should be on every SQL Server DBA/Developers book shelf!
|
|
|
| |
|
