|
SQL Server 2000 Design & T-SQL Programming |  | Authors: Michael Reilly, Michelle Poolet
Publisher: Osborne/McGraw-Hill
Category: Book
List Price: $48.95
Buy Used: $0.16
as of 9/9/2010 11:06 EDT details
You Save: $48.79 (100%)
New (3) Used (15) from $0.16
Seller: your_online_bookstore
Rating:  reviews
Sales Rank: 2287532
Media: Paperback
Edition: 1st
Pages: 612
Number Of Items: 1
Shipping Weight (lbs): 2.7
Dimensions (in): 9 x 7.4 x 2
ISBN: 0072123753
Dewey Decimal Number: 005.7585
UPC: 783254032828
EAN: 9780072123753
ASIN: 0072123753
Publication Date: December 29, 2000
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Build the best SQL Server 2000 database solution for your organization. This book explains how to design a robust, scalable SQL Server 2000 database model, planning for business requirements, data integrity, and security. You'll learn to write queries and develop custom reports and views and create stored procedures, functions, and triggers in T-SQL.
|
| Customer Reviews:
 Buy in the year 2006, for your reference shelf. December 21, 2006
Reuben Gathright (United States)
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 November 29, 2005
Walid Magd (Redmond, WA USA)
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).
 Not nearly enough information on design March 9, 2001
Dwayne Soylemezoglu (Istanbul, Turkey)
9 out of 9 found this review helpful
This book is OK, but gives the impression that you will learn how to design a SQL Server 2000 database, not as an academic computer science exercise, but for what I need it for - work! There's only 4 chapters on the design, not nearly enough information on normalization, and the remainder of the book - using SQL Server 2000 - was covered far more comprehensively in Rob Veera's book from Wrox Press. In short, OK for a complete beginner but not nearly enough meat for those who need to know this information on a daily basis.
Great book on SQL Server logic February 24, 2001
Alex Kaczmarek (Canberra, ACT Australia)
4 out of 6 found this review helpful
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.
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. TSQL Tutorials | |
