Pro SQL Server 2008 Relational Database Design and Implementation [Apress].pdf

(12259 KB) Pobierz
373656884 UNPDF
The eXperT’s Voice ® in sQl serVer
SQL Server 2008
Relational Database
Design and Implementation
Design for performance! Create optimized SQL
Server databases that scale well and are logically
sound in order to meet your business requirements.
Louis Davidson
With Kevin Kline, Scott Klein, and Kurt Windisch
Foreword by Paul Nielsen,
SQL Server MVP
Pro
373656884.047.png 373656884.057.png 373656884.068.png 373656884.078.png 373656884.001.png 373656884.004.png 373656884.005.png 373656884.006.png 373656884.007.png 373656884.008.png 373656884.009.png 373656884.010.png 373656884.011.png 373656884.012.png 373656884.013.png 373656884.014.png 373656884.015.png 373656884.016.png 373656884.017.png 373656884.018.png 373656884.019.png 373656884.020.png 373656884.021.png 373656884.022.png 373656884.023.png 373656884.024.png 373656884.025.png 373656884.026.png 373656884.027.png 373656884.028.png 373656884.029.png 373656884.030.png 373656884.031.png 373656884.032.png 373656884.033.png 373656884.034.png 373656884.035.png 373656884.036.png 373656884.037.png 373656884.038.png 373656884.039.png 373656884.040.png
 
373656884.041.png
 
373656884.042.png
 
373656884.043.png
 
373656884.044.png
 
373656884.045.png 373656884.046.png 373656884.048.png 373656884.049.png 373656884.050.png 373656884.051.png 373656884.052.png 373656884.053.png 373656884.054.png 373656884.055.png 373656884.056.png
 
373656884.058.png 373656884.059.png 373656884.060.png 373656884.061.png 373656884.062.png 373656884.063.png 373656884.064.png 373656884.065.png 373656884.066.png 373656884.067.png 373656884.069.png 373656884.070.png 373656884.071.png 373656884.072.png 373656884.073.png 373656884.074.png
 
373656884.075.png 373656884.076.png 373656884.077.png 373656884.079.png 373656884.080.png 373656884.081.png 373656884.082.png 373656884.083.png 373656884.084.png
 
Pro SQL Server 2008
Relational Database
Design and
Implementation
Louis Davidson
With Kevin Kline, Scott Klein,
and Kurt Windisch
373656884.085.png 373656884.086.png 373656884.087.png
Pro SQL Server 2008 Relational Database Design and Implementation
Copyright © 2008 by Louis Davidson
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): 978-1-4302-0866-2
ISBN-13 (electronic): 978-1-4302-0867-9
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.
Java™ and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc., in the
US and other countries. Apress, Inc., is not affiliated with Sun Microsystems, Inc., and this book was writ-
ten without endorsement from Sun Microsystems, Inc.
Lead Editor: Jon Gennick
Technical Reviewers: Wayne Snyder, Evan Terry, Don Watters
Editorial Board: Clay Andres, Steve Anglin, Ewan Buckingham, Tony Campbell, Gary Cornell,
Jonathan Gennick, Matthew Moodie, Joseph Ottinger, Jeffrey Pepper, Frank Pohlmann,
Ben Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh
Project Manager: Tracy Brown Collins
Copy Editors: Heather Lang, Kim Wimpsett
Associate Production Director: Kari Brooks-Copony
Production Editor: Ellie Fountain
Compositor: Lynn L’Heureux
Proofreader: Patrick Vincent
Indexer: Broccoli Information Management
Artist: Kinetic Publishing Services, LLC
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 orders- ny@springer-sbm.com , or
For information on translations, please contact Apress directly at 2855 Telegraph Avenue, Suite 600, Berkeley,
CA 94705. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com , or visit http://www.apress.com .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our Special
Bulk Sales–eBook Licensing web page at http://www.apress.com/info/bulksales .
The information in this book is distributed on an “as is” basis, without warranty. Although every precau-
tion 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 http://www.apress.com .
373656884.002.png
To my father-in-law, Verlin Wheeler. He passed away during the writing of this book, and I
really never got to know him as I was told he was in his younger days. At the very least, he
rivaled my love for gadgets and was an early adopter of lots of technology, like satellite
dishes and even computers. I use his computer every day to manage my media collection—
he probably would have liked that, though I think he would have preferred to have used
the media in the library.
373656884.003.png
Zgłoś jeśli naruszono regulamin