MCTS: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide (Exam 70-431)

679 Pages·2006·19.417 MB·English

by  Joseph L. Jorden, Dandy Weyn

25654ffirs.fm Page iii Tuesday, June 13, 2006 1:21 AM
MCTS
®
Microsoft™ SQL Server 2005
Implementation and Maintenance
Study Guide
(Exam 70-431)
Joseph L. Jorden
Dandy Weyn
Wiley Publishing, Inc.
25654ffirs.fm Page ii Tuesday, June 13, 2006 1:21 AM
25654ffirs.fm Page i Tuesday, June 13, 2006 1:21 AM
MCTS
®
Microsoft™ SQL Server 2005
Implementation and Maintenance
Study Guide
(Exam 70–431)
25654ffirs.fm Page ii Tuesday, June 13, 2006 1:21 AM
25654ffirs.fm Page iii Tuesday, June 13, 2006 1:21 AM
MCTS
®
Microsoft™ SQL Server 2005
Implementation and Maintenance
Study Guide
(Exam 70-431)
Joseph L. Jorden
Dandy Weyn
Wiley Publishing, Inc.
25654ffirs.fm Page iv Tuesday, June 13, 2006 1:21 AM
Acquisitions and Development Editor: Maureen Adams
Technical Editors: Marcellus Duffy and Marilyn Miller-White
Production Editor: Daria Meoli
Copy Editor: Kim Wimpsett
Production Manager: Tim Tate
Vice President and Executive Group Publisher: Richard Swadley
Vice President and Executive Publisher: Joseph B. Wikert
Vice President and Publisher: Neil Edde
Permissions Editor: Shannon Walters
Media Development Specialist: Steven Kurdirka
Book Designer: Judy Fung
Compositor and Illustrator: Jeffrey Wilson, Happenstance Type-O-Rama
Proofreader: Nancy Riddiough
Indexer: Ted Laux
Cover Designer: Archer Design
Copyright © 2006 by Wiley Publishing, Inc., Indianapolis, Indiana
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN-13: 978-0-470-02565-9
ISBN-10: 0-470-02565-4
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 permitted under Sec-
tions 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Pub-
lisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222
Rosewood Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher for per-
mission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianap-
olis, IN 46256, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.
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 competent pro-
fessional person should be sought. Neither the publisher nor the author shall be liable for damages arising here-
from. 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 Web-
sites 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 or to obtain technical support, please contact our Customer
Care Department within the U.S. at [phone], outside the U.S. at [phone] or fax [phone].
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 Cataloging-in-Publication Data is available from the publisher.
TRADEMARKS: Wiley, the Wiley logo, and the Sybex logo 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 trademarks or registered trademarks of Microsoft Corpora-
tion in the United State 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.
10 9 8 7 6 5 4 3 2 1
25654ffirs.fm Page v Tuesday, June 13, 2006 1:21 AM
To Our Valued Readers:
Thank you for looking to Sybex for your Microsoft SQL Server 2005 certification exam prep
needs. The Sybex team at Wiley is proud of its reputation for providing certification candi-
dates with the practical knowledge and skills needed to succeed in the highly competitive IT
workplace. Just as Microsoft Learning is committed to establishing measurable standards
for certifying individuals who design and maintain SQL Server 2005 systems, Sybex is com-
mitted to providing those individuals with the skills needed to meet those standards.
The authors and editors have worked hard to ensure that the Study Guide you hold in your
hands is comprehensive, in-depth, and pedagogically sound. We’re confident that this book
will exceed the demanding standards of the certification marketplace and help you, the SQL
Server 2005 certification candidate, succeed in your endeavors.
As always, your feedback is important to us. If you believe you’ve identified an error in the
book, please visit the Customer Support section of the Wiley web site. Or if you have general
comments or suggestions, feel free to drop me a line directly at [e-mail]. At Sybex
we’re continually striving to meet the needs of individuals preparing for certification exams.
Good luck in pursuit of your SQL Server 2005 certification!
Neil Edde
Vice President & Publisher
Sybex, an Imprint of John Wiley & Sons
25654ffirs.fm Page vi Tuesday, June 13, 2006 1:21 AM
For my wife, Rachelle
—Joseph L. Jorden
For my little cousin Gunnar and all other kids with muscular dystrophy
—Dandy Weyn
25654ffirs.fm Page vii Tuesday, June 13, 2006 1:21 AM
Acknowledgments
Like all the books I’ve written and tech edited for Sybex over the years, this has been quite a
ride. A lot of work goes into these books, and it is not all from the authors. When it comes time
for accolades, the first person who comes to mind is our acquisitions editor, Maureen Adams.
She got the ball rolling and kept it rolling the whole time. I would also like to thank the pro-
duction editor, Daria Meoli; the copy editor, Kim Wimpsett; and the tech editors, Marcellus
Duffy and Marilyn Miller-White for all their hard work in making the book a success.
I owe my friends and family a special thanks because they supported me throughout my
writing odyssey even though they didn’t quite understand what it was that I was writing about.
First, my family: Mary (a.k.a. Mom); Buddy and Shelly Jorden; and Janet, Colin, and Leian
McBroom—thanks to all of you. Also, when I started to lose my sanity, there were those who
helped me look for it (we’ll find it yet!): I have to thank Zerick Campbell (Big Daddy Z); his
lovely and talented wife, Tanya; and the boys, Jostin and Brenton. Thanks to everyone at Jelly
Belly; there is no better place to work than a candy company. For all the laughs I have to thank
Nick Saechow—you rock (insert noun here)! Special thanks to Jyles McDonald for working
with me all those early mornings; let’s do it again sometime. Most important, though, thanks
to my wife, Rachelle Jorden, for her patience and understanding as I wrote yet another book.
Finally, thanks to all of you for reading this work. May it serve you well. —Joseph L. Jorden
From my part, I want to thank Joseph L. Jorden for his dedication and support as an expe-
rienced writer. I would not have been able to complete this work without the support of our
acquisitions editor, Maureen Adams. Thanks, Maureen—you had so much patience with me.
A special thanks goes to Cristian Lefter, who supplied a lot of questions and additional tech
review for this book; I am really looking forward to writing a book together one day.
Thanks also to all my friends for their support, and please let’s not forget my mom and stepdad!
Unfortunately, I spent a lot of time writing instead of playing tour guide on their first U.S. visit.
A special thanks to my special friend and fellow MCT Paul Silva. Thanks, Paul, for taking
care, for being concerned when I got stressed, and for being such a close friend. Also, thanks to
the entire Microsoft Certified Trainer community, who gave me the opportunity to train on SQL
Server 2005 and harden my skills on the product by all the interesting questions they devised.
And thanks to all of you reading this, and congratulations on your interest in becoming
a Microsoft Certified Technology Specialist on SQL Server 2005. Finally, a big thank you
to the Microsoft SQL Server product team members who made this product so successful
and built all these cool features. —Dandy Weyn