Sybase Transact SQL Guidelines Best Practices

Rating:
Summary: Could have been better
Review: Got a free copy at TechWave 2004. It looked promising, but I was disappointed: I could not find much substantial material that will really help me as a DBA. This book claims to be much more than it delivers, as its actually pretty superficial. I just cannot recommend spending $45 on this book -- it doesn't add much to what's already available for free (in Sybase's own manuals).

Rating:
Summary: DBA and Developer books Sybase & MS
Review: Having read this book I agree with the majority of the reviewers here that by far this book is the best Sybase Transact-SQL book I have seen around. With regard to the comments on specific chapters, the fragmentation Chapter covering the details and its associated shell script described in the appendix are excellent and very useful. We have started using the script in production and it does work. Also the chapter on tempdb optimization is really cool. I liked it style.

Rating:
Summary: Good TSQL Book
Review: I am new to Sybase having been an Oracle developer for sometime. Migration from PL/SQL to T-SQL is not that easy. However, I found this book very useful in helping me out with T-SQL concepts. I can also use it as a shelf reference for all my Sybase T-SQL needs.

Rating:
Summary: A very good Sybase book
Review: I have almost finished this book and I have found it extremely useful. It is straight to the point and very good at certain areas such as the choice of indexes, detailed explanations on Data Access, Search Arguments, Various Best Practices and guidelines on using cursors in Sybase and generating Unique Keys. In my opinion it is $45 well spent.

Rating:
Summary: Higly recommended T-SQL book
Review: I have read this book and I have found it really good. It is well written in simple enough language even for juniors to follow. Practical examples are very good. Tuning and optimisation examples are excellent and so is tempdb recommendations. By far the best Sybase book I have seen

Rating:
Summary: Books on Sybase Transact SQL
Review: I have read this book and it is by far the best Sybase book I have seen in so many years. It covers up to the latest version of ASE 12.5.2. It is packed with practical examples although I would have liked to see more. I guess you can put so much in a book. It is useful for both the developers and DBAs. The chapters on tempdb optmization, working out fragmentation and purge and archiving will be very handy for DBAs. Very much recommended for both the average and the more experienced readers

Rating:
Summary: MS & Sybase Transact SQL books
Review: I work as a developer in NY with both MIcrosoft and Sybase. I have found this book very useful. It saves me from accessing Sybase manuals. The other book that I use is the O'reilly Transact-SQL Programming. However, that book only covered up to Sybase 11.5 and is well out of date. So I am pleased to see this new Sybase Transact SQL book out.

Rating:
Summary: Looking for more
Review: I would characterize this book as 95% verbatim from the already existing Sybase ASE manuals, and 5% of a somewhat meandering, undetailed, and quite vague description of some important topics. Take for instance a 2 page "chapter" on sort buffers. Nothing there helps me to tune that part of the server. It's also full of some of the long known myths to performance, such as the 80% "rule" the optimizer uses to determine when to use an index. The chapter on fragmentation is also somewhat incoherent, and incomplete and includes algorithms for determining fragmentation that are not sound.

All in all, I like that there is some movement in the ASE publishing ranks, but I was hoping for much more from this publication.

Rating:
Summary: New Sybase ASE books
Review: My colleague attended Sybase TechWave 2004 and received a copy of this book from Sybase. I have read it and I like its style. The authors have tried to explain complex topics in practical terms. I was most impressed by chapters covering Data Access, Query Tuning, Cursors and Joins. I recommend it to every Transact SQL developer Sybase or Microsoft. It covers practical aspects without being tedious.

Rating:
Summary: Excellent layout and approach to Transact SQL
Review: This book is fantastic! It's by far the best Transact SQL book I have ever read! It covers even the latest procedures and functions up to ASE 12.5.2 If you are working with Transact SQL, this book is an absolute must have!