Pro SQL Server 2005 Database Design and Optimization and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Start reading Pro SQL Server 2005 Database Design and Optimization on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pro SQL Server 2005 Database Design and Optimization [Paperback]

Louis Davidson , Kurt Windisch , Kevin Kline

RRP: 47.49
Price: 36.79 & FREE Delivery in the UK. Details
You Save: 10.70 (23%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 29 July? Choose Express delivery at checkout. Details
‹  Return to Product Overview

Table of Contents

Louis Davidson with Kevin Kline and Kurt Windisch Pro SQL Server 2005 Database Design and Optimization Pro SQL Server 2005 Database Design and Optimization Copyright (c) 2006 by Louis Davidson,Kevin Kline, and Kurt Windisch All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher. ISBN-13 (pbk): 981-1-59059-529-9 ISBN-10 (pbk): 1-59059-529-7 Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1 Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. Lead Editor: Matthew Moodie Technical Reviewers: Dejan Sarka, Andrew Watt Editorial Board: Steve Anglin, Ewan Buckingham, Gary Cornell, Jason Gilmore, Jonathan Gennick, Jonathan Hassell, James Huddleston, Chris Mills, Matthew Moodie, Dominic Shakeshaft, Jim Sumser, Keir Thomas, Matt Wade Project Manager: Elizabeth Seymour Copy Edit Manager: Nicole LeClerc Copy Editors: Susannah Pfalzer, Nicole LeClerc Assistant Production Director: Kari Brooks-Copony Production Editor: Laura Esterman Compositor: Lynn L Heureux Proofreader: Lori Bring Indexer: Valerie Perry Cover Designer: Kurt Krames Manufacturing Director: Tom Debolski Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail, or visit For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone 510-549-5930, fax 510-549-5939, e-mail, or visit The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work. The source code for this book is available to readers at in the Source Code section. Contents at a Glance Foreword ... xv About the Authors ... xvii About the Technical Reviewers ... xix Acknowledgments ... xxi Introduction ... xxiii *CHAPTER 1 Introduction to Database Concepts... 1 *CHAPTER 2 Data Modeling ... 33 *CHAPTER 3 Conceptual Data Modeling ... 71 *CHAPTER 4 The Normalization Process ... 121 *CHAPTER 5 Implementing the Base Table Structures ... 181 *CHAPTER 6 Protecting the Integrity of Your Data ... 273 *CHAPTER 7 Securing Access to the Data ... 335 *CHAPTER 8 Table Structures and Indexing ... 395 *CHAPTER 9 Coding for Concurrency ... 439 *CHAPTER 10 Code-Level Architectural Decisions ... 489 *CHAPTER 11 Database Interoperability ... 541 *APPENDIX A Codd s 12 Rules for an RDBMS ... 573 *APPENDIX B Datatype Reference ... 581 *INDEX ... 613 v

‹  Return to Product Overview