by Robert D. Schneider and Darril Gibson
Microsoft
®
SQL
Server
®
2008
ALL-IN-ONE DESK REFERENCE
FOR
DUMmIES
‰
01_179543-ffirs.qxp 8/23/08 12:23 AM Page i
by Robert D. Schneider and Darril Gibson
Microsoft
®
SQL
Server
®
2008
ALL-IN-ONE DESK REFERENCE
FOR
DUMmIES
‰
01_179543-ffirs.qxp 8/23/08 12:23 AM Page i
Microsoft
®
SQL Server
®
2008 All-in-One Desk Reference For Dummies
®
Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2008 by Wiley Publishing, Inc., Indianapolis, Indiana
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or
by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit-
ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written
permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the
Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600.
Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing,
Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4355, or online at
http://www.wiley.com/go/permissions.
Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the
Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, and related trade
dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United
States and other countries, and may not be used without written permission. Microsoft and SQL Server
are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other
trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated with any
product or vendor mentioned in this book.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS
OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND
SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A
PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS.
THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS
SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING,
OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPE-
TENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE LIABLE
FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN THIS
WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THE
AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR
RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN
THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT
IS READ.
For general information on our other products and services, please contact our Customer Care
Department within the U.S. at 800-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002.
For technical support, please visit www.wiley.com/techsupport.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may
not be available in electronic books.
Library of Congress Control Number: 2008933788
ISBN: 978-0-470-17954-3
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
01_179543-ffirs.qxp 8/23/08 12:23 AM Page ii
About the Authors
Robert D. Schneider has more than 15 years of experience developing and
delivering sophisticated software solutions worldwide. He has provided tech-
nical and business expertise on topics such as Service Oriented Architecture
(SOA), database optimization, and distributed computing to a wide variety of
enterprises in the financial, technology, and government sectors. Clients have
included Chase Manhattan Bank, VISA, HP, SWIFT, Booz Allen Hamilton, and
the governments of the United States, Mexico, Brazil, and Malaysia.
Robert is the author of Optimizing Informix Applications, Microsoft SQL Server:
Planning and Building a High Performance Database, MySQL Database Design
and Tuning, and SQL Server 2005 Express For Dummies. He has also written
numerous articles on technical and professional services topics and has been
quoted as a subject matter expert in publications worldwide. He can be
reached at Robert.Schneider@Think88.com.
Darril Gibson has been a Microsoft Certified Trainer (MCT) for more than
nine years, providing training on SQL Server (since SQL Server version 7.0)
and a wide variety of other Microsoft technologies. He is currently contracted
with the U.S. Air Force, providing extensive technical training to Air Force
personnel in support of a major network operations support center. He holds
nearly 20 current certifications and has been certified in each SQL Server ver-
sion since SQL Server 7.0.
Darril is the author of MCITP: SQL Server 2005 Database Administration All-In-
One and MCITP: SQL Server 2005 Database Developer All-In-One. He developed
several video training courses for Keystone Learning on several certification
topics including A+, MCSE, and Microsoft Exchange. He has also developed
several courses teaching technical topics at the college and university level,
and for U.S. government clients.
Dedication
To my family for their support, patience, and encouragement.
—Robert D. Schneider
To my loving wife of 16 years who I’m grateful to also call my best friend.
—Darril Gibson
Authors’ Acknowledgments
The authors want to acknowledge the following people for their invaluable
assistance in creating and publishing this work: Carole McLendon, Nicole
Sholly, Kyle Looper, Brian Walls, Toni Settle, Joan K. Griffitts.
01_179543-ffirs.qxp 8/23/08 12:23 AM Page iii
