| Welcome to vBulletin FAQ |
vBulletin FAQ Navigation
Getting Started
Customizing your vBulletin
Search Engines & SEO
Making Money with a Forum
Promoting your Community
|
| Get your own vBulletin Today |
|
| Webmaster Help |
|
|
|
The Guru's Guide to Transact-SQL
vBulletin Book Store > vBulletin books beginning with G
|
The Guru's Guide to Transact-SQL |
Author: Ken Henderson
Published: 2000-03-04 |
List price: $64.99
Our price: $40.94
|
Usually ships in 24 hours
As of: October 08th, 2008 05:58:18 AM
|
|
|
Customer comments on this selection.
 Outdated
The downside to this book is that it is from 2000, and the code snippets are no longer available online. Also, since this book was written, there is a new Microsoft SQL Server product called 2005, that this book doesn't talk about obviously.
I don't recommend this book, because I really only got a few tips out of it. It's not suited well for a beginner or advanced user. It just kind of covers the whole range. And it's time to move on to books that use the latest software.
 If I could only have one book for sql server...
...this would be it.
I have worked with Microsoft SQL Server day in and day out for many years now, and I have owned this book ever since it first came out. I have had some pretty funky tasks to perform with data and this book has come through with excellent solutions each and every time. I absolutely cannot tout it highly enough. It is easy to read, and full of actually useful code examples and information rather than pages of code printouts that are just filler.
If you work writing code for SQL Server, this book belongs on your bookshelf, if not on your desk.
 Excellent material, just getting a bit long in the tooth
I bought this book seven years ago when doing my MCDBA in SQL Server 7.0. At the time I was focussing on getting my certifications and upon a cursory browsing, just couldn't get into this book.
Well it's now 2007, and having spent the last 7 years working with SQL Server 7.0, 2000 and 2005 I decided it was time to try this book again. I mention this to give a reference to where I'm coming from when I type the following comments.
First up, with the passage of time since publication, one would expect the material in this book to be well out of date - and as it turns out, you would not be disappointed. So before reading, I checked if any newer editions had been published since the first edition, and discovered there have been none - an assumed expectation considering the success of this book and that SQL Server has been updated and will continue to do so. As a consequence, expect some of the material and examples to be somewhat outdated (Transact-SQL syntax and methods have changed somewhat since publication). As an example, the section on error handling in stored procedures chapter has been outdated with TRY...CATCH exception handling, along with other examples of Transact-SQL syntax flagged to be retired.
All that aside, the true value in this book is the Transact-SQL samples. The author progresses through a problem using increasingly advanced SQL statements and explains each along the way. There is a sequence of chapters on "Runs and Sequences", "Arrays", "Sets" and "Hierarchies" that I thought could have been referenced elsewhere with more pages spent on practical areas of interest. Otherwise, as you can read from other reviews, the material covered is generally of a high standard.
As stated in other reviews, this is not a "Learn Transact-SQL" book, but more of a "Here is some Transact-SQL code that might help you".
The CD included contains just the Transact-SQL code samples from the book and is arranged in per chapter folder hierarchy.
Overall - a great if not somewhat terse effort. However, an updated version covering the Transact-SQL language changes in SQL 2005 would make this a 5 star book.
Great recommendation!
This book was recommended by a SQL consultant our company hired to improve the speed of our servers and it was well worth it! It covered a lot of the topics he had trained us on and gave very easy to follow examples.
Don't waste your time - buy this book
Although it's billed as a T-SQL book and it's written specifically for SQL Server 2000, I'd recommend this book for anyone who wants to learn more about SQL. Programming books are by and large a wasteland of fluff, bloat, poor writing, sloppy mistakes, and misinformation - this book is a happy exception. The writer clearly knows his stuff, he writes in a no-nonsense conversational style, and he has a knack for zeroing in on the tricky subtleties and making them clear. This is practically unheard of in the realm of programming literature. (Since writing this series of books, the author has been hired by the evil empire in Redmond, so I wouldn't expect his next book to be nearly as disarmingly frank and insightful as this one.)
|
Similar Listings
|
|
Our vBulletin book picks:
|
|
Find more vBulletin related products of interest.
|
