SQL Server 2000 Design and T-SQL Programming

by Michelle Poolet and Michael Reilly

-- SQL Server has a 50% marketshare in the NT database category and is continuing to grow-- Database design is complicated, and not well covered in the marketplace. This book will be in high demand by... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072123753
• ISBN13: 9780072123753
• Release Date: December 2000
• Publisher: McGraw-Hill Companies
• Length: 612 Pages
• Weight: 2.80 lbs.
• Dimensions: 1.7" x 7.4" x 9.0"

Customer Reviews

Buy in the year 2006, for your reference shelf.

I have been using this book for four years now. I used it yesterday to look up the syntax for the CONVERT statement in relation to date/time formatting, for use in a SQL 2005 stored procedure. I could say more, but chances are that if you are reading this, you should get it anyway. I predict this book will be used for years to come because SQL 2000 is the heart of many DB systems.

Excellent book

It is really sad that a serious piece of work like this book doesn't get the deserved appreciation. Five years ago, I started my first steps with SQL-Server 2000 using this book and I admire it deeply and I am very thankful for the authors' efforts. It is true I had to scratch my head 10 times an hour, but this had nothing to do with the writing style, the book is full of information, ideas, design guide lines and I had to keep up. While reading this book, you will never hear the angry voice in your head saying "Get to the point" or "What is the God d.... point". You are not going to cry as a lousy sense of humor's side effect. You also are not going to be insulted by pre made assumption that you are duh and you have to be instructed, in killing details, how to tie your shoes. Unlike some other red books writers, the authors didn't care about inflating the page count to justify an over priced, few pounds of blah, blah and more blah. I read this book cover to cover, more than once, and I assure you this is the book you want to read if you want to get the most for your time. Just be aware that the authors neither treat you as a baby nor are willing to tell you any bed time stories. The book has a scientific writing style, words and paragraphs were chosen carefully and meticulously to strike the point at heart, nonsense was cut down to zero. We all know that design is the art of balancing trade offs. The authors didn't save any efforts making you fully aware of your options explaining in details the when(s) why(s) and how(s) to, or not to, apply them based on an educated decision not a good luck wish. Don't take my word for it, grab the book and read any chapter, CH16 Indexes or CH18 Triggers for example and then compare by reading the same chapters in Professional SQL-Server (Wrox) which is amazingly overrated compared to this book which is amazingly underrated. You will see the differences immediately. If the book claimed to be "Professional Blah,...", I would take one star out for not covering some important subjects (the details of using Index Tuning Wizard for example) in more detailed way (the same subject is not covered in Wrox's Professional SQL-Server either).

Great book on SQL Server logic

This book has been specifically written for database administrators, designers or programmers who want to know more about logic behind SQL2000 GUI. This book also can be a significant step to understand T-SQL and database design and implementations. In particular for someone preparing for the MS certification exam on SQL7 or 2000 DB implementation, this book should be the first to start. After reading this book you should be well advanced in using not only proper T-SQL syntax but also understand execution plans in Query Analyzer. This book can give you a fresh view to understand how to design and write to get optimum from SQL Server. Final words in my review: this book is rather not for beginners but can give you info on SQL real world challenges.