Microsoft SQL Server 2008 Step by Step

Contents at a Glance Part I Getting Started with Microsoft SQL Server 2008 1 Overview of Microsoft SQL Server 2 Installing and Configuring SQL Server 2008 3 Using the Tools in SQL Server 2008 Part II Designing Databases 4 Creating Databases 5 Designing Tables 6 Indexes 7 Partitioning Part III Retrieving and Manipulating Data 8 Data Retrieval 9 Advanced Data Retrieval 10 Data Manipulation Part
Nội dung trích xuất từ tài liệu:
Microsoft SQL Server 2008 Step by Step PUBLISHED BY Microsoft Press A Division of Microsoft Corporation One Microsoft Way Redmond, Washington 98052-6399 Copyright © 2009 by Mike Hotek All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. Library of Congress Control Number: 2008935428 Printed and bound in the United States of America. 1 2 3 4 5 6 7 8 9 QWT 3 2 1 0 9 8 Distributed in Canada by H.B. Fenn and Company Ltd. A CIP catalogue record for this book is available from the British Library. Microsoft Press books are available through booksellers and distributors worldwide. For further infor mation about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send comments to mspinput@microsoft.com. Microsoft, Microsoft Press, Active Directory, ActiveX, Excel, Internet Explorer, MSDN, PowerPoint, SQL Server, Visio, Visual Basic, Visual C#, Visual Studio, Windows, Windows Server, and Windows Vista are either registered trademarks or trademarks of the Microsoft group of companies. Other product and company names mentioned herein may be the trademarks of their respective owners. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book. Acquisitions Editor: Ken Jones Developmental Editor: Sally Stickney Project Editor: Denise Bankaitis Editorial Production: S4Carlisle Publishing Services Technical Reviewer: Randall Galloway; Technical Review services provided by Content Master, a member of CM Group, Ltd. Cover: Tom Draper Design Body Part No. X15-12274 A02L626041.indd 2 10/8/2008 5:29:01 PM To Genilyn, You make it all worthwhile. A03D626041.indd iii 9/29/2008 3:31:12 PM A03D626041.indd A03D626041.indd iv 9/29/2008 3:31:12 PM Contents at a Glance Getting Started with Microsoft SQL Server 2008 Part I 1 Overview of Microsoft SQL Server . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2 Installing and Configuring SQL Server 2008. . . . . . . . . . . . . . . . . 15 3 Using the Tools in SQL Server 2008 . . . . . . . . . . . . . . . . . . . . . . . . 31 Designing Databases Part II 4 Creating Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 5 Designing Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 6 Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 7 Partitioning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Retrieving and Manipulating Data Part III 8 Data Retrieval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 9 Advanced Data Retrieval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137 10 Data Manipulation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 Designing Advanced Database Objects Part IV 11 Views. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 12 Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 13 Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199 14 Triggers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 213 15 Database Snapshots . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219 16 Service Broker . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225 17 Full-Text Indexing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247 Database Management Part V 18 Security. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 19 Policy-Based Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 289 20 Data Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . ...