Thank this author by sharing:
By Steve Jones,
by Itzak Ben-Gan and Tom Moreau
5 Stars -
I glanced through this book in the bookstore one day and it looked like a good learning
tool to improve my T-SQL code. I consider myself fairly advanced in this area, but
after reading the "Gurus guide" I know I can improve. I used to recommend The Guru's
Guide to Transact-SQL as the one book to get for T-SQL. This book is as good, perhaps,
better than that one. You cannot go wrong with this book as a T-SQL reference.
From the beginning, I was not disappointed with this book. I opened this book and read
the first chapter on Joins (a fairly simple topic), and then learned a few things. One
thing I really like is the emphasis on SQL-92 standards. This is nice for a few reasons.
One, it helps you prepare for other RDBMS, which any of us may find ourselves working with at
any time. Second, SQL Server is moving in this direction and at some
point (perhaps SQL 2003), support for the SQL-89 join syntax may disappear.
I found something useful in more every chapter. I made some notes about the content and
helpful items I found. The book broken down into the following chapters:
There were a few problems with this book. In the first chapter, the authors talk about the
reasons to switch to SQL-92 standards. The first reason that is highlighted, however, is Reason #8.
I couldn't find reasons 1-7, so this leads me to worry about the copy editing and it
means I have to suspect and verify all the information I read. Despite the few problems I found, I found very
few typos in this book. The code could be typed into Query Analyzer and it worked and returned the results
that the authors intended.
This book is a fantastic reference for SQL Server 2000. Users of SQL Server 7 (or 6.5) will still learn things, but
there are quite a few features that are only available in SQL Server 2000. If you do not have this book or
The Guru's Guide to Transact-SQL, I highly recommend you pick up a copy of this book.
©dkRanch.net September 2001
Return to Steve Jones Columnist Home
Learn about SQL Server 2008 Reporting Services with this new title from Wiley. We have a sample chap...
Are you looking for a head start on learning about SQL Server 2005? Able to get to Reading in the UK...
A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and pre...
Chapter 3 from Murach’s SQL Server 2008 for Developers shows you how to retrieve data from a databas...
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.