In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000.
Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.
Customer Reviews
Average Rating:
Rating: - sloppy, amateurish, and impractical
problem 1 is that the authors obviously aren't developers. they're a couple of guys who like sql puzzles. much of the code in this book has little or no practical value. you should not use it in production systems because it will not perform well and will be difficult to maintain. it's like they're trying to show off some way of getting a complex result set with a single select and not even thinking about the performance impact of the code or its maintainability. that kind of stuff is cool to newbies, ... Read More
Rating: - Not only not advanced-not beginner either
If advanced means more than I know with only 2-1/2 years with Sql then this is not an advanced book. It is mostly puzzles and things like that-not anything really useful in the real world. The worst part of it is all the errors in the code. There must be dozens of these-but where is the errata?
I have a lot of comp. books and this one has more beginner mistakes and typoes than any others I have read. Not advanced and not beginner-not sure who is supposed to read it.
Rating: - Lots of good, more not-so-good
On the positive side, there are numerous interesting Transact SQL techniques demonstrated in this book. A couple of them have proved to be very useful to me. I like the exploration of different challenges people face with Transact SQL and the solutions the authors provide.
I also like the catalog nature of the book. APress is getting better at this with their books, and this one is pretty good as a reference.
On the negative side, the language is misued often in this book. As the ... Read More
Rating: - A commentary on Critiques:
A common theme among the negative critiques, is the use of the word "Advanced" in the book's title. Personally, i think the authors should simply have chosen a different title, and half of the negative comments would have been subdued. (Something to signify the apparent intent of the authors, such as "An anthology of T-SQL", or "A Comprehensive Introduction to T-SQL" ...) "Advanced" of course is to some extent a product of one's own thinking, and experience. Another aspect to this subject of "Advanced" ... Read More
Rating: - Crisp, clear and very practical...
This is the most reliable and advanced source of information about TSQL for me. I love this book. It's examples are crisp, clear and very practical. Great job!
- Not only not advanced-not beginner either
- A commentary on Critiques:
- Crisp, clear and very practical...
