MS.SQL.Server.2008.R2.Unleashed.PDF资源-CSDN文库

SQLServer

2008

5星 · 超过95%的资源需积分: 13 170 浏览量 2013-10-28 12:46:10 上传评论收藏 47.93MB PDF 举报

资源推荐

资源详情

资源评论

ptg

Microsoft SQL Server 2008 R2 Unleashed

system, or transmitted by any means, electronic, mechanical, photocopying, recording,

or otherwise, without written permission from the publisher. No patent liability is

assumed with respect to the use of the information contained herein. Although every

precaution has been taken in the preparation of this book, the publisher and author

assume no responsibility for errors or omissions. Nor is any liability assumed for

damages resulting from the use of the information contained herein.

ISBN-13: 978-0-672-33056-8

ISBN-10: 0-672-33056-3

Library of Congress Cataloging-in-Publication Data is on file.

Printed in the United States of America

First Printing September 2010

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks

have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of

this information. Use of a term in this book should not be regarded as affecting the

validity of any trademark or service mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possi-

ble, but no warranty or fitness is implied. The information provided is on an “as is”

basis. The author(s) and the publisher shall have neither liability nor responsibility to

any person or entity with respect to any loss or damages arising from the information

contained in this book or from the use of the CD or programs accompanying it.

Bulk Sales

Pearson offers excellent discounts on this book when ordered in quantity for bulk

purchases or special sales. For more information, please contact:

U.S. Corporate and Government Sales

1-800-382-3419

corpsales@pearsontechgroup.com

For sales outside of the U.S., please contact:

International Sales

+1-317-581-3793

international@pearsontechgroup.com

Publisher

Paul Boger

Editor In Chief

Karen Gettman

Acquisitions Editor

Neil Rowe

Development Editor

Mark Renfrow

Managing Editor

Sandra Schroeder

Project Editor

Seth Kerney

Copy Editor

Chuck Hutchinson

Indexer

Erika MIllen

Proofreader

Leslie Joseph

Debbie Williams

Technical Editor

Rebecca M. Riordan

J. Boyd Nolan

Publishing

Coordinator

Romney French

Multimedia Developer

Dan Scherf

Designer

Gary Adair

Compositor

Mark Shirar

ptg

Contents at a Glance

Introduction....................................................................................................1

Part I Welcome to Microsoft SQL Ser ver

1 SQL Server 2008 Overview..............................................................................9

2 What’s New in SQL Server 2008...................................................................35

3 Examples of SQL Server Implementations ...................................................51

Part II SQL Server Tools and Utilities

4 SQL Server Management Studio ...................................................................63

5 SQL Server Command-Line Utilities ..........................................................103

6 SQL Server Profiler ......................................................................................121

Part III SQL Server Administration

7 SQL Server System and Database Administration......................................165

8 Installing SQL Server 2008..........................................................................185

9 Upgrading to SQL Server 2008 ...................................................................227

10 Client Installation and Configuration .......................................................263

11 Security and User Administration ..............................................................291

12 Data Encryption..........................................................................................335

13 Security and Compliance............................................................................359

14 Database Backup and Restore .....................................................................377

15 Database Mail..............................................................................................427

16 SQL Server Scheduling and Notification ....................................................449

17 Administering SQL Server 2008 with PowerShell ......................................481

18 SQL Server High Availability ......................................................................523

19 Replication ..................................................................................................545

20 Database Mirroring .....................................................................................617

21 SQL Server Clustering .................................................................................655

22 Administering Policy-Based Management..................................................687

Part IV Database Administration

23 Creating and Managing Databases .............................................................709

24 Creating and Managing Tables ...................................................................741

25 Creating and Managing Indexes ................................................................791

26 Implementing Data Integrity......................................................................811

27 Creating and Managing Views in SQL Server ............................................837

28 Creating and Managing Stored Procedures ................................................869

Download from www.wowebook.com

ptg

29 Creating and Managing User-Defined Functions. .....................................917

30 Creating and Managing Triggers . ..............................................................949

31 Transaction Management and the Transaction Log . ................................995

32 Database Snapshots. .................................................................................1043

33 Database Maintenance. ............................................................................1069

Part V SQL Server Performance and Optimization

34 Data Structures, Indexes, and Performance . ...........................................1091

35 Understanding Query Optimization . ......................................................1209

36 Query Analysis . ........................................................................................1301

37 Locking and Performance .........................................................................1341

38 Database Design and Performance . .........................................................1403

39 Monitoring SQL Server Performance. ......................................................1427

40 Managing Workloads with the Resource Governor . ...............................1493

41 A Performance and Tuning Methodology. ..............................................1519

Chapters on the CD

Part VI SQL Server Application Develop-

ment

42 What’s New for Transact-SQL in SQL Server 2008. .................................1551

43 Transact-SQL Programming Guidelines, Tips, and Tricks . ......................1637

44 Advanced Stored Procedure Programming and Optimization.................1733

45 SQL Server and the .NET Framework . .....................................................1787

46 SQLCLR: Developing SQL Server Objects in .NET . .................................1825

47 Using XML in SQL Server 2008 . ..............................................................1865

48 SQL Server Web Services . .........................................................................1927

49 SQL Server Service Broker . .......................................................................1959

50 SQL Server Full-Text Search . ....................................................................1997

Part VII SQL Server Business Intelligence Features

51 SQL Server 2008 Analysis Services. ..........................................................2029

52 SQL Server Integration Services . ..............................................................2099

53 SQL Server 2008 Reporting Services . .......................................................2169

Part VIII Bonus Chapters

54 Managing Linked and Remote Servers . ...................................................2243

55 Configuring, Tuning, and Optimizing SQL Server Options . ..................2273

56 SQL Server Disaster Recovery Planning. ..................................................2329

Index

2353

Download from www.wowebook.com

剩余2497页未读，继续阅读

评论收藏

内容反馈

Harryyang_2009

2014-04-07

SQL Server 2008权威之作。
causacn

2013-12-19

不错，有没有SQL Server 2008类似的书

xaliuyang

粉丝: 5
资源: 39

MS.SQL.Server.2008.R2.Unleashed.PDF

Sams.Microsoft.SQL.Server.2008.R2.Unleashed.part2

Sams.Microsoft.SQL.Server.2008.R2.Unleashed.part1

Sams.Microsoft.SQL.Server.2008.Reporting.Services.Unleashed.Jul.2009.rar

[Microsoft.SQL.Server.2008.R2.Unleashed].(Ray)影印版.rar

[Microsoft.SQL.Server.2008.R2.Unleashed].(Ray)影印版.part2.rar

Sams.Windows.Server.2008.R2.Unleashed.Jan.2010.rar

SQL Server 2008 R2 教程 Unleashed.pdf

SQL Server 2008 R2详解手册.pdf

SQL Server 2008 R2 UNLEASHED

Sams.Microsoft.Windows.Home.Server.Unleashed.Mar.2010.rar

Sams.System.Center.Operations.Manager.OpsMgr.2007.R2.Unleashed.Apr.2010.rar

Sams.Microsoft.Windows.Server.2003.Unleashed.R2.Edition.May.2006.chm

SQL.Server.2005.Unleashed part7

Linux.Programming.Unleashed.Second.Edition.pdf

Sams.Publishing.Ubuntu.Unleashed.2008.Edition.pdf

Sams.Microsoft.Lync.Server.2010.Unleashed

SQL.Server.2005.Unleashed

Sams.Windows.Presentation.Foundation.Unleashed.Dec.2006.part2

Sams.IronRuby.Unleashed.Feb.2010.pdf

Sams.Microsoft.XNA.Game.Studio.3.0.Unleashed.pdf

数据库课程设计：高校教务管理系统（Java代码、SQL代码、报告）

药品说明书数据库，共计11万+条药品说明书，目前再SQL2008R2数据库验证成功

sqlserver离线安装包

sqljdbc.zip

SQL Server2019中文安装包，Sql server，sql2019，SQL安装包，SQL Server2019

2019年最新5级全国行政区划数据库（包括乡镇村）

sql server2019离线安装包

java实现简易社团管理系统.zip

数据库课程设计-订餐系统（PowerBuilder+SQL Sever）

Sql Server2019安装包

最新资源