数据库与数据仓库实用操作大全 英文本PDF|Epub|txt|kindle电子书版本网盘下载

数据库与数据仓库实用操作大全 英文本PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Part1 Introduction and Overview1

Chapter1 Welcome to the SQL Server2000 Reference Library3

Chapter2 Failover Clustering7

Creating a Failover Cluster9

Upgrading to a SQL Server 2000 Failover Cluster15

Handling a Failover Cluster Installation15

Maintaining a Failover Cluster21

Using SQL Server Tools with Failover Clustering22

Failover Cluster Troubleshooting24

Part2 Creating and Maintaining Databases27

Chapter3 Databases29

Parts of a Database29

Files and Filegroups30

Transaction Logs35

Database Design Considerations37

Creating a Database Plan37

Online Transaction Processing vs.Decision Support39

Normalization41

Data Integrity44

Data Security45

Database Performance46

Maintenance47

Estimating the Size of a Database47

Creating a Database56

Using Raw Partitions58

Modifying a Database59

Expanding a DatabaseI60

Shrinking a Database61

Creating Filegroups63

Changing the Default Filegroup64

Setting Database Options64

Creating a Removable Database74

Attaching and Detaching a Database75

Renaming a Database76

Changing the Database Owner77

Transaction Termination for Changing Database States77

Displqying Database and Transaction Log Space78

Documenting and Scripting Databases78

Viewing a Database78

Database Maintenance Plan Wizard79

Deleting a Database80

Chapter4 Tables81

Designing Tables81

Specifying a Column Data Type82

Text in Row Data87

Autonumbering and Identifier Columns90

Using Constraints,Defaults,and Null Values90

Creating and Modifying a Table100

Modifying Column Properties102

Adding and Deleting Columns104

Creating and Modifying PRIMARY KEY Constraints104

Creating and Modifying FOREIGN KEY Congstraints105

Creating and Modifying UNIQUE Constraints107

Creating and Modifying CHECK Constraints108

Creating and Modifying DEFAULT Definitions109

Creating and Modifying Identifier Columns110

Viewing a Table111

Deleting a Table112

Chapter5 Indexes113

Designing an Index114

Creating an Index125

Rebuilding an Index137

Viewing an Index138

Deleting an Index138

Renaming an Index138

Chapter6 Views141

Scenarios for Using Views142

Creating a View144

Designing an Indexed View146

Creating an Indexed View150

Creating a Partitioned View154

Modifying and Renaming a View160

Modifying Data Through a View161

Getting Information About a View163

Deleting a View163

Chapter7 Stored Procedures165

Extended Stored Procedures166

Creating a Stored Procedure167

Specifying Parameters169

Programming Stored Procedures173

Returning Data from a Stored Procedure181

Executing a Stored Procedure186

Automatic Execution of Stored Procedures187

Modifying and Renaming a Stored Procedure188

Recompiling a Stored Procedure188

Viewing a Stored Procedure189

Deleting a Storde Procedure190

Chapter8 Enforcing Business Rules With Triggers191

Designing Triggers193

Trigger Execution194

Specifying When a Trigger Fires194

Designing INSTEAD OF Triggers195

Creating a Trigger198

Programming Triggers200

Using Triggers that Include ROLLBACK TRANSACTION202

Using the inserted and deleted Tables203

Multirow Considerations205

Conditional INSERT Trigger207

Specifying First and Last Triggers209

Using Nested Triggers211

Using INSTEAD OF Triggers214

Using text ,ntext,and image Data in INSTEAD OF Triggers223

Activating Triggers with Implicit and Explicit Null Values224

Viewing a Trigger226

Modifying and Renaming a Trigger226

Deleting a Trigger227

Chapter9 User-Defined Functions229

User-Defined Functions That Return a Table Data Type233

Inline User-Defined Functions234

Deterministic and Nondeterministic Functions237

Rewriting Stored Procedures as Functions240

Using Extended Properties on Database Objects241

Chapter10 Full-Text Indexes245

Administering Full-Text Features Using SQL Enterprise Manager247

Administering Full-Text Features Using Stored Procedures and Scalar Functions247

Enabling Others to Issue Full-Text Queries249

Performing Investigation and Clean-up Tasks for Full Text Catalogs252

Performing Infrequent Tasks254

Maintaining Full-Text Indexes255

Filtering Supported File Types257

Column-Level Linguistic Analysis258

Part3 Creating and Using Data Warehouses259

Chapter11 Data Warehousing Overview261

SQL Server 2000 Tools for Data Warehouses261

Chapter12 Parts of a Data Warehouse265

Data Marts265

Relational Databases267

Data Sources267

Data Preparation Area268

Presentation Services269

End-User Analysis272

Chapter13 Creating a Data Warehouse273

Designing a Data Warehouse273

Using Dimensional Modeling275

Fact Tables275

Aggregation Tables277

Dimension Tables278

Indexes281

Creating the Data Preparation Area281

Creating the Data Warehouse Database282

Extracting Data from Operational Systems283

Cleansing and Transforming Data284

Loading Data into the Data Warehouse Database285

Preparing Presentation Information287

Distributing Data to Data Marts287

Chapter14 Using a Data Warehouse289

SQL Queries290

OLAP and Data Mining291

English Query291

Microsoft Office 2000292

Web Access and Reporting292

Offline OLAP Cubes293

Third-Party Applications293

Custom Applications294

Chapter15 Maintaining a Data Warehouse295

Updating Data Warehouse Data295

Scheduling Data Updates296

Synchronizing OLAP Cubes297

Updating Data Marts298

Administering a Data Warehouse298

Backing Up Data Warehouse Data299

Automating Data Warehouse Tasks300

Tuning Data Warehouse Performance300

Part4 Optimizing Database Performance301

Chapter16 Designing Federated Database Servers303

Designing Partitions304

Designing Federated Database Servers for High Availability307

Backing Up and Restoring Federated Database Servers308

Logical Database Design309

Chapter17 Database Design309

Database Design Considerations:Data Types310

Physical Database Design311

RAID311

Partitioning319

Data Placement Using Filegroups321

Index Tuning Recommendations323

Optimizing Transaction Log Performance324

Optimizing tempdb Performance325

File Systems326

Chapter18 Query Tuning327

Analyzing a Query329

Graphically Displqying the Execution Plan Using SQL Query Analyzer330

Logical and Physical Operatiors335

Query Tuning Recommendations355

Advanced Query Tuning Concepts357

Understanding Nested Loops Joins358

Understanding Merge Joins358

Understanding Hash Joins359

Chapter19 Application Design361

Networking and Performance364

Named Pipes vs,TCP/IP Sockets364

Optimizing Application Performance Using Efficient Data Retrieval365

Effects of Transactions and Batches on Application Performance367

Effects of Stored Procedures on Application Performance368

Understanding and Avoiding Blocking369

Optimizing Distributed Queries371

Chapter20 Optimizing Utility and Tool Performance375

Optimizing Backup and Restore Performance375

Optimizing Bulk Copy Performance379

Optimizing DBCC Performance382

Chapter21 Optimizing Server Performance383

Optimizing Server Performance Using Memory Configuration Options383

Optimizing Server Performance Using I/O Configuration Options385

Optimizing Server Performance Using Windows NT Options386

Maximizing Throughput386

Configuring Server Tasking386

Configuring Virtual Memory387

IndexA Topics in the SQL Server 2000 Reference Library389

IndexB Index of Optimizing Database Performance Elements421