Designing SQL Server 2000 Databases

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9781928994190 | 1928994199
Cover: Paperback
Copyright: 2/22/2001

eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.

$62.34*

The Microsoft .NET initiative is the future of e-commerce - making it possible for organisations to build a secure, reliable e-commerce infrastructure. This is the first book to outline the capabilities of SQL Server 2000, one of the key components of .NET. SQL Server 2000 introduces powerful new data mining functionality designed specifically to capture and process customer profiles and to predict future buying patterns on e-commerce sites. Designing SQL Server 2000 Databases for NET Enterprise Servers addresses the needs of IT professionals migrating from the popular SQL 7 databases to the new SQL 2000, as well as those who are starting from scratch. * Covers all key features of SQL Server 2000 including; XML support, enhanced data-mining capabilities and integration with Windows 2000 * While there are many books available on SQL 7 - this is the first to be announced for SQL 2000 * Free ongoing customer support and information upgrades

Introduction

xxvii

SQL Server 2000 Overview and Migration Strategies

(56)

Introduction

(1)

Overview of SQL Server 2000: A. NET Enterprise Server

(5)

The Future of Windows DNA: Microsoft.NET

(4)

New and Enhanced Features of SQL Server 2000

(24)

XML Support

(4)

Development Tools and Technologies

(1)

Query Analyzer

(1)

New Data Types

(1)

Indexed Views

(1)

Trigger Enhancements

(1)

Referential Integrity Enhancements

(1)

User - Defined Functions

(1)

Index Enhancements

(1)

Shared Session Information

(1)

Collation Support

(1)

Extended Properties

(1)

Meta Data Services

(1)

Analysis Services

(1)

OLAP Enhancements

(1)

Data Mining

(1)

SQL Server Administration

(1)

Windows 2000 Active Directory Integration

(1)

Scalability and Availability

(1)

Scalability Enhancements

(1)

Distributed Partitioned Views

(1)

Fail-Over Clustering

(1)

Log Shipping

(1)

Data Transformation Services

(1)

Replication Services

(1)

Active Directory Integration

(1)

Queued Updating Subscribers

(1)

Multiple Server Instance Support

(2)

Web and Internet Standards Support

(1)

Web Access Using Hypertext Transfer Protocol

(1)

Secure Sockets Layer

(1)

SQL Server 2000 Versions, Features, and Requirements

(9)

Common Edition Requirements

(1)

SQL Server Licensing and Pricing

(1)

Enterprise Edition

(1)

Hardware Requirements and Capacity Limits

(1)

Operating System Compatibility

(1)

Standard Edition

(1)

Hardware Requirements

(1)

Software and Operating System Compatibility

(1)

Personal Edition

(1)

Hardware Requirements

(1)

Software and Operating System Compatibility

(1)

Developer Edition

(1)

SQL Server 2000 Desktop Engine

(1)

SQL Server 2000 Windows CE Edition

(2)

Should You Migrate to SQL Server 2000?

(2)

How Will SQL Server 2000 Benefit My Organization?

(1)

Will SQL Server 2000 Fit into My Organization?

(1)

Steps to a Successful SQL Server Migration

(9)

Planning a SQL Server Migration

(1)

Determine Existing and Future Application Requirements

(1)

Inventory Existing Database Servers

(1)

Train Database Administrators and Support Personnel

(1)

Next Steps to Successful SQL Server Migration

(1)

Migrating to SQL Server 2000

(3)

Upgrading from SQL Server 6.5: Active/Passive Mode

(1)

Upgrading from SQL Server 6.5: Active/Active Mode

(1)

Upgrading from SQL Server 7.0: Active/Passive Mode

(1)

Upgrading from SQL Server 7.0: Active/Active Mode

(2)

Summary

(2)

FAQs

(3)

Installing and Configuring SQL Server 2000

(36)

Introduction

(1)

Planning a SQL Server Installation

(12)

Installation Requirements

(1)

Hardware Requirements

(1)

Software Requirements

(1)

SQL Server Licensing

(1)

Installation Options

(1)

Local vs. Remote Installation

(2)

Creating Service Accounts for SQL Server

(1)

Changing User Accounts

(1)

Disk Imaging Support

(1)

Answer File for Automated Installations

(1)

Multiple Server Instances

(1)

Collation Options

(1)

Upgrading to SQL Server 2000

(2)

Installing SQL Server

(5)

Standard Installation

(4)

Advanced Installation

(1)

Configuring Cluster Support

(1)

Unattended Installation

(1)

Configuration Options and Settings

(16)

SQL Server Properties

(10)

Server Network Utility

(1)

Client Network Utility

(2)

SQL Server Agent

(1)

SQL Mail

(2)

Summary

(1)

FAQs

(1)

SQL Server Scalability and Availability

(34)

Introduction

(1)

Scaling Up vs. Scaling Out

(4)

TPC Benchmarks

(1)

SQL Server Fail-Over Clustering

(11)

SQL 2000 Fail-Over Clustering Architecture

(1)

Planning for SQL Server Clustering

(1)

Clustering Capabilities and Requirements

100

(1)

Microsoft Cluster Service

101

(1)

System Area Networks

101

(1)

Shared Disks

102

(1)

Log Shipping

102

(1)

Implementing Fail-Over Clustering

102

(1)

Setting Up Network Adapters

103

(1)

Setting Up Shared Disks

103

(1)

Setting Up MSCS on NT 4.0

104

(1)

Setting Up MSCS on Windows 2000 (Advanced Server/Datacenter Server)

104

(1)

Upgrading to SQL Fail-Over Clustering

105

(3)

Setting Up SQL Server 2000 Fail-Over Clustering

108

(1)

Distributed Partitioned Views

109

(6)

Federated Servers

109

(2)

Data Partitioning

111

(1)

Creating Distributed Partitioned Views

111

(1)

Creating Linked Servers

111

(1)

Partitioning Your Data

112

(1)

Creating a Distributed View

112

(1)

Using and Updating a Distributed View

113

(2)

Log Shipping

115

(6)

Setting Up Log Shipping

116

(4)

Monitoring Log Shipping

120

(1)

Indexed Views

121

(3)

Requirements for an Indexed View

122

(2)

Creating an Indexed View

124

(1)

Summary

124

(1)

FAQs

125

(2)

Designing and Creating SQL Server Databases

127

(62)

Introduction

128

(1)

SQL Server 2000 Architecture

128

(16)

Relational Databases

129

(2)

SQL Server System Databases

131

(1)

Master

132

(1)

TempDB

132

(1)

msdb

133

(1)

Model

134

(1)

Pubs

134

(1)

Northwind

135

(1)

Physical Storage Architecture

135

(1)

Filegroups

136

(1)

Data Files

137

(1)

Transaction Logs

137

(1)

Indexes

138

(1)

SQL Server Services

139

(1)

SQL Server Service

139

(3)

SQL Server Agent Service

142

(1)

Microsoft Distributed Transaction Coordinator Service

142

(1)

Microsoft Search Service

143

(1)

MSSQLServerADHelper Service

143

(1)

MSSQLServerOLAPService

143

(1)

Creating SQL Server Databases

144

(7)

Designing Your Database Solution

144

(1)

Database Modeling

145

(1)

Designing the Physical Database

146

(1)

The Disk Subsystem

146

(2)

Capacity and Growth Planning

148

(3)

Creating and Configuring Your Database

151

(29)

Getting Started

151

(2)

Using the Create Database Wizard

153

(2)

Create Database Wizard: Name the Database and Specify Its Location

155

(1)

Create Database Wizard: Name the Database Files

155

(1)

Create Database Wizard: Define the Database File Growth

156

(1)

Create Database Wizard: Name the Transaction Log Files

156

(1)

Create Database Wizard: Define the Transaction Log File Growth

157

(1)

Create Database Wizard: Completing the Create Database Wizard

158

(1)

Configuring Your Database

158

(3)

Southwind Properties | Filegroups

161

(1)

Southwind Properties | Data Files

162

(2)

Southwind Properties | Transaction Log

164

(1)

Southwind Properties | Options

164

(4)

Southwind Properties | Permissions

168

(1)

Reviewing the Southwind Configuration

168

(1)

Using T-SQL to Create and Alter a Database

169

(2)

Monitoring and Maintenance

171

(1)

Database Maintenance Plan Wizard

171

(1)

Maintenance Plan Wizard: Select Databases

172

(1)

Maintenance Plan Wizard: Update Data Optimization Information

172

(2)

Maintenance Plan Wizard: Database Integrity Check

174

(1)

Maintenance Plan Wizard: Specify the Database Backup Plan

175

(1)

Maintenance Plan Wizard: Specify the Backup Disk Directory

175

(1)

Maintenance Plan Wizard: Specify the Transaction Log Backup Plan

176

(1)

Maintenance Plan Wizard: Specify Transaction Log Backup Disk Directory

177

(1)

Maintenance Plan Wizard: Reports to Generate

177

(1)

Maintenance Plan Wizard: Maintenance Plan History

178

(1)

Maintenance Plan Wizard: Completing Your Maintenance Plan

178

(2)

Database Modeling Tools

180

(6)

Entity-Relationship Diagrams

180

(4)

SQL Server Database Designer

184

(2)

Summary

186

(2)

FAQs

188

(1)

Database and Server Security

189

(54)

Introduction

190

(1)

Planning SQL Server Security

190

(12)

Understanding SQL Server Security

191

(2)

C2 Certification

193

(1)

Administration Access and Server Security

194

(1)

Configuring the SQL Server 2000 Service Accounts

194

(3)

Securing the SQL Server 2000 Executable and Data Files

197

(1)

Object and Data Security

197

(1)

Securing Login Access to SQL Server

198

(1)

Assigning Privileges to Perform Serverwide Operations

199

(1)

Granting Access to Databases

199

(1)

Grouping Users into Database Roles

200

(1)

Using Views, Stored Procedures, and User-Defined Functions to Simplify Security

201

(1)

Network Communications Security

201

(1)

Security Options in SQL Server

202

(29)

Understanding the Windows Authentication Mode

202

(3)

Understanding the SQL Authentication Mode

205

(1)

Database Users, Roles, and Permissions

206

(1)

Selecting a Security Mode

207

(1)

SQL Server and Windows Authentication

207

(3)

Windows-Only Authentication Mode

210

(1)

Logins

210

(1)

Adding New Windows Logins

210

(6)

Server Roles

216

(1)

Fixed Roles

216

(2)

Database Users

218

(1)

Adding New Database Users

219

(2)

The Guest User Account

221

(1)

Assigning User Permissions

222

(3)

Database Roles

225

(1)

Fixed Roles

225

(2)

User-Defined Roles

227

(4)

Implementing Database and Server Security

231

(8)

The Scenario

231

(1)

User Authentication

232

(1)

Operating System Administrative Access

233

(1)

Windows 2000

233

(1)

SQL Server Logins

234

(1)

Assigning Permissions

234

(1)

Adding Users to Database Roles

234

(1)

Assigning Permissions to Users and Roles

235

(1)

Network Communications Security

236

(1)

Multiprotocol Encryption

236

(1)

SSL Support

237

(2)

IPSec in Windows 2000

239

(1)

Summary

239

(1)

FAQs

240

(3)

Administration and Active Directory Integration

243

(52)

Introduction

244

(1)

Windows 2000 Active Directory Integration

244

(18)

Registering SQL Servers in Active Directory

246

(1)

SQL Server Properties

246

(2)

sp_ActiveDirectory_SCP

248

(1)

Registering Databases in Active Directory

249

(1)

Database Properties

249

(1)

SQL Replication Services and Active Directory

249

(1)

SQL Server 2000 Replication

250

(7)

Registering Publications in Active Directory

257

(1)

Locating and Using Publications in Active Directory

258

(2)

Analysis Services and Active Directory

260

(1)

Registering Analysis Servers in Active Directory

261

(1)

Tools and Techniques for SQL Server Administration

262

(13)

Windows 2000 Active Directory

262

(1)

Active Directory Users and Computers

263

(2)

Microsoft Management Console

265

(1)

SQL Server Enterprise Manager

266

(7)

SQL Server MMC Snap-Ins

273

(2)

Moving and Copying SQL Server Databases

275

(7)

Enterprise Manager

277

(1)

Copy Database Wizard

278

(3)

Detaching and Attaching Databases

281

(1)

Linked Servers

282

(2)

Distributed Queries

284

(1)

Database Maintenance Tools

284

(6)

DBCC

285

(1)

Database Maintenance Plans

286

(1)

Maintenance Plan Wizard

286

(2)

SQL-DMO

288

(2)

Automating Administrative Tasks

290

(3)

SQL Server Agent

290

(1)

Alerts and Operators

290

(1)

SQL Mail

290

(2)

Setting Up Operators

292

(1)

Defining Alerts

292

(1)

Summary

293

(1)

FAQs

294

(1)

SQL Server Backup and Recovery

295

(64)

Introduction

296

(1)

Planning and Implementing a Successful Backup and Recovery Strategy

296

(23)

Determining Data Recovery Requirements

296

(1)

Frequency of Database Changes

297

(1)

Cost of Data Loss and Availability

298

(1)

Planning for Hardware Failure

299

(1)

The Tape Unit

299

(1)

The Disk Unit

300

(1)

The Server

301

(1)

The Network

301

(1)

Selecting a Backup Strategy

302

(1)

Backup Strategy Options

302

(2)

Database Backup Options

304

(3)

Backup Storage

307

(1)

Determining Storage Requirements

307

(4)

Backup Storage Media

311

(2)

Media Sets, Media Families, and Multiple Drives

313

(2)

Secure Offsite Storage

315

(1)

Sample Backup Scheme

315

(2)

Creating a Recovery Strategy

317

(2)

Backup and Restore Tools and Techniques

319

(3)

The Create Database Backup Wizard

319

(1)

The Database Maintenance Plan Wizard

320

(1)

Transact---SQL

321

(1)

Backing Up SQL Server Databases

322

(22)

Performing a Database Backup

323

(12)

Backing Up System Databases

335

(9)

Restoring SQL Server Databases

344

(10)

Restoring a Database Backup

344

(4)

Restoring System Databases

348

(4)

Database Options and Settings

352

(2)

Testing Your Backup and Recovery Strategy

354

(1)

Summary

355

(1)

FAQs

356

(3)

Microsoft English Query and Full-Text Search

359

(48)

Introduction

360

(1)

Overview of English Query

360

(6)

What's New in English Query?

362

(1)

More Powerful Applications

363

(1)

Installing English Query

364

(1)

Installing English Query

364

(1)

Installation Requirements

365

(1)

Creating an English Query Application

366

(10)

Planning Your English Query Application

366

(1)

Understanding Users' Questions

366

(1)

Creating an English Query Project

367

(1)

English Query Project Components

368

(1)

English Query SQL Project

369

(1)

Creating an English Query SQL Project Using the SQL Project Wizard

370

(1)

English Query OLAP Project

371

(2)

The English Query Model

373

(3)

Building and Deploying Your English Query Application

376

(5)

Implementing Web-Based English Query Applications

376

(1)

Testing Your English Query Application

377

(2)

Putting It All Together

379

(1)

Creating a Web-Based English Query Solution

379

(2)

An Overview of Full-Text Search

381

(6)

File Filtering

381

(1)

Full-Text Search Architecture

382

(1)

Microsoft Search Service

382

(1)

Performance Considerations for Full-Text Indexes

383

(4)

Enabling Full-Text Search

387

(6)

Creating a Full-Text Catalog

387

(1)

Enabling a Database for Full-Text Search

388

(1)

Enabling a Table for Full-Text Search

388

(1)

Enabling a Column for Full-Text Search

389

(1)

Creating a Full-Text Index on the Products Table in the Northwind Database

390

(1)

Building the Full-Text Index

391

(2)

Querying Full-Text Indexes

393

(5)

FREETEXT and FREETEXTTABLE

393

(2)

CONTAINS and CONTAINSTABLE

395

(3)

Administering Full-Text Catalogs and Indexes

398

(5)

Backing Up Full-Text Catalogs

399

(2)

Populating Full-Text Indexes

401

(1)

Scheduling Index Rebuilds

402

(1)

Summary

403

(1)

FAQs

404

(3)

Importing and Exporting Data

407

(46)

Introduction

408

(1)

Overview of Data Import and Export Tools

408

(2)

Data Transformation Services

410

(9)

What's New in DTS?

410

(2)

Data Transformation Services Architecture

412

(1)

Packages

413

(1)

Tasks

413

(1)

Transformations

414

(1)

Connections

415

(1)

Package Workflow

415

(1)

Security in DTS Packages

416

(1)

DTS Performance Considerations

417

(2)

Creating and Editing DTS Packages

419

(10)

Creating a Simple Package

419

(1)

DTS Import/Export Wizard

420

(1)

Copying a Table Between Databases

421

(1)

DTS Designer

422

(1)

Creating a Data Connection

422

(1)

Creating a Task

423

(4)

Saving DTS Packages

427

(1)

Saving to a SQL Server

427

(1)

Saving to Meta Data Services

428

(1)

Saving to a DTS Package File

428

(1)

Saving to a Visual Basic Script File

429

(1)

Executing DTS Packages

429

(4)

Executing a Package in the DTS Designer Interface

430

(1)

Executing a Package in SQL Enterprise Manager

430

(1)

Executing a Package Using the dtsrun.exe Utility

430

(2)

Executing a Package Using the dtsrunul.exe Utility

432

(1)

Executing a Package Programmatically in Visual Basic

432

(1)

The Bulk Copy Program

433

(7)

Using BCP

436

(4)

SQL-DMO BulkCopy

440

(4)

Using the BulkCopy Object

440

(4)

The BULK INSERT Command

444

(3)

Using BULK INSERT

445

(2)

Choosing a Data Import and Export Method

447

(2)

Import/Export Job Requirements

447

(1)

Existing Data Format

448

(1)

Frequency of Import or Export Task

448

(1)

Data Manipulation Tasks

448

(1)

Performance Considerations

449

(1)

Summary

449

(1)

FAQs

450

(3)

SQL Server Analysis Services

453

(46)

Introduction

454

(1)

Online Analytical Processing and Data Mining

454

(5)

OLTP vs. OLAP vs. Data Warehousing

455

(3)

Data Mining

458

(1)

New Features in Analysis Services

459

(2)

OLAP Enhancements

459

(1)

Cubes

459

(1)

Storage Locations

459

(1)

Actions

459

(1)

Access from Client Applications

460

(1)

Dimensions

460

(1)

Security

460

(1)

Integrating the Add-Ins

461

(1)

Data-Mining Capabilities

461

(1)

The Analysis Services Architecture

461

(5)

Analysis Server

461

(1)

Analysis Manager

462

(2)

Cubes

464

(1)

Mining Models

465

(1)

PivotTable Service

466

(1)

Decision Support Objects

466

(1)

Installing Analysis Services

466

(3)

Analysis Services Requirements

467

(1)

Installing Analysis Services for the First Time

467

(1)

Upgrading from Earlier Versions

468

(1)

Designing and Building an OLAP Solution

469

(6)

Designing and Building a Data Warehouse

469

(1)

Normalization vs. Denormalization

470

(1)

Components of a Data Warehouse

470

(1)

Populating Data Warehouses

470

(1)

Using DTS to Transform and Load Data

471

(3)

Creating an Analysis Services Database

474

(1)

Create a Database and Data Source

474

(1)

Designing and Building Cubes

475

(5)

Using the Cube Wizard

475

(4)

Editing Cubes

479

(1)

Data Security in Cubes

479

(1)

Defining Measures and Dimensions

480

(2)

Understanding Measures and Dimensions

480

(1)

Creating and Editing Measures and Dimensions

480

(2)

Using Your OLAP Solution

482

(3)

Querying Cubes

482

(1)

HTTP Cube Access

483

(1)

Multidimensional Expressions

483

(2)

Data Mining in SQL Server

485

(7)

Mining Models

485

(1)

Relational Data-Mining Models

485

(1)

OLAP Data-Mining Models

486

(1)

Data Mining Algorithms

486

(1)

Creating and Editing Data-Mining Models

486

(1)

Mining Model Wizard

487

(1)

OLAP Mining Model Editor

488

(1)

Using Data-Mining Models

488

(1)

Data-Mining Training

488

(1)

Data-Mining Model Browser

489

(2)

Multidimensional Expressions for Data Mining

491

(1)

OLE DB for Data Mining

491

(1)

Security in Analysis Services

492

(2)

Users and Groups

492

(1)

Roles

492

(1)

Data Security

493

(1)

Implementing Security in Analysis Services

493

(1)

Accessing Analysis Services Over the Web

494

(1)

Configuring IIS for Analysis Services

494

(1)

Performance Tuning and Optimization

495

(1)

Usage Analysis Wizard

495

(1)

Usage-Based Optimization Wizard

496

(1)

Summary

496

(2)

FAQs

498

(1)

Using XML with SQL Server

499

(46)

Introduction

500

(1)

Overview of XML and SQL Server Support

500

(10)

What Is XML?

500

(1)

The Benefits of XML

501

(1)

Working with XML

502

(1)

XML Documents

502

(2)

Extensible Stylesheet Language

504

(1)

XML Data-Reduced Schemas

505

(1)

XML Path Language

506

(3)

XML Support and Limitations in SQL Server

509

(1)

Additional XML Resources on the Web

509

(1)

W3C.org

510

(1)

Biztalk.org

510

(1)

XML.org

510

(1)

MSDN.Microsoft.com/XML

510

(1)

HTTP and URL Query Support

510

(8)

Configuring IIS for HTTP Query Support

510

(1)

Creating a Database Virtual Directory in IIS

511

(1)

Querying SQL Server Using HTTP

512

(1)

Supported Query Methods Using HTTP

513

(1)

Executing SQL Using HTTP

513

(2)

Creating an XML Query Template

515

(1)

Executing XML Query Templates

516

(2)

XPath Queries

518

(4)

Overview of XPath Queries and SQL Server Limitations

518

(1)

XPath Limitations in SQL Server

519

(1)

Additional Information on the XML Path Language Specification

519

(1)

XPath Data Types and Conversions

519

(1)

Using XPath Queries

520

(2)

Select...For XML

522

(3)

FOR XML Syntax and Use

522

(3)

Limitations of FOR XML

525

(1)

XML Views

525

(9)

XML Data-Reduced Schemas

526

(3)

Mapping XML Data to Database Tables and Columns

529

(1)

SQL Server XML View Mapper

530

(1)

Using the SQL Server View Mapper

530

(4)

Using and Updating XML Data

534

(9)

Updategrams

534

(1)

Downloading SQL Server 2000 XML Updategrams Support

534

(1)

Understanding Updategrams

535

(1)

T-SQL OPENXML Statement sp_xml_preparedocument and sp_xml_removedocument

536

(3)

ActiveX Data Objects

539

(1)

XML Support in ADO 2.6

539

(4)

Summary

543

(1)

FAQs

544

(1)

Database Replication Techniques and Configuration

545

(52)

Introduction

546

(1)

SQL Server Replication Architecture

546

(4)

Publisher

546

(1)

Subscriber

547

(1)

Distributor

547

(1)

Publication

547

(1)

Article

547

(1)

Subscription

548

(1)

SQL Server Agent

548

(1)

Replication Agents

548

(1)

New Replication Features in SQL Server

549

(1)

Replication Compatibility

550

(2)

Previous Versions of SQL Server

550

(1)

Heterogeneous Publishers and Subscribers

551

(1)

Heterogeneous Subscribers

551

(1)

Heterogeneous Publishers

552

(1)

Designing for Database Replication

552

(8)

Replication Requirements

552

(1)

Data Location

552

(1)

Data Modification

552

(1)

Connection Bandwidth and Availability

553

(1)

Application and Database Design Considerations

553

(1)

Minimize Potential Conflicts

554

(1)

Table RowGuid and Identity Values

555

(5)

Replication Methods in SQL Server

560

(5)

Transactional Replication

560

(1)

Queued Updating Subscribers

561

(1)

Merge Replication

561

(2)

Snapshot Replication

563

(1)

Selecting a Replication Method

564

(1)

Configuring SQL Server Replication

565

(10)

Enabling Server Publishing

565

(1)

Assigning a Distributor Server

565

(1)

Creating Publications

566

(1)

Create Publication Wizard

567

(2)

Adding Subscribers

569

(1)

Push vs. Pull Subscriptions

569

(2)

Replicating Data Over the Internet

571

(1)

Replicating Via a Virtual Private Network

571

(1)

Replicating Through Microsoft Proxy Server

571

(2)

Replication Via FTP

573

(1)

Configuring a Publisher or Distributor to Listen on TCP/IP

573

(1)

Configuring a Publication to Allow Subscribers to Retrieve Snapshots Using FTP

574

(1)

Configuring a Subscription to Use FTP to Retrieve a Snapshot

575

(1)

Dealing with Replication Conflicts

575

(5)

Replication Conflict Viewer

576

(1)

Viewing Conflicts

577

(1)

Row-Level vs. Column-Level Conflict Tracking

577

(1)

Resolving Conflicts

577

(2)

Default Resolvers vs. Custom Resolvers

579

(1)

SQL Server CE Edition Replication Features

580

(2)

Windows CE Subscribers

581

(1)

Replication and Active Directory Integration

582

(3)

Registering Publications in Active Directory

582

(2)

Browsing and Subscribing to Publications in Active Directory

584

(1)

Replication Performance Considerations

585

(3)

Hardware Upgrades

586

(1)

How to Enhance Snapshot and Transactional Replication Performance

587

(1)

How to Enhance Transactional Replication Performance

588

(1)

How to Enhance Merge Replication Performance

588

(1)

Replication Backup Strategies

588

(6)

Backing Up and Restoring Snapshot Replication

590

(1)

Backup and Restore of Transactional Replication

590

(1)

Using Log Shipping as a Backup to Transactional Replication

590

(1)

Backing Up and Restoring Merge Replication

591

(1)

How to Restore a Replicated Database from Backup

591

(3)

Summary

594

(1)

FAQs

595

(2)

Programming Tools and Technologies in SQL Server

597

(54)

Introduction

598

(1)

Overview of SQL Server Programming

598

(1)

New Programming Features in SQL Server 2000

599

(25)

Data Types

600

(1)

Bigint

600

(1)

Sql_variant

601

(2)

Table

603

(1)

Query Analyzer

604

(3)

SQL Debugger

607

(2)

User-Defined Functions

609

(1)

Scalar User-Defined Functions

610

(1)

Table User-Defined Functions

611

(1)

Inline User-Defined Functions

612

(1)

Referential Integrity Enhancements

613

(1)

Cascading Updates and Deletes

613

(1)

Trigger Enhancements

614

(1)

INSTEAD OF

614

(2)

AFTER

616

(1)

Indexed Views

617

(5)

Meta Data Services

622

(2)

Transact-SQL

624

(9)

Data Definition Language

625

(1)

Data Manipulation Language

626

(5)

Data Control Language

631

(2)

Data Access Tools and Technologies

633

(6)

Command-Line Utilities

633

(1)

ADO, OLE DB, and ODBC

634

(5)

Programming Administrative Tasks

639

(6)

Distributed Management Objects

640

(2)

Namespaces

642

(1)

Analysis Services Programming

643

(2)

DTS Programming

645

(1)

Replication Programming

646

(1)

Meta Data Services Programming

647

(1)

Summary

648

(1)

FAQs

649

(2)

Performance-Tuning Tools and Techniques

651

(44)

Introduction

652

(1)

Partitioning Data and Federated Database Servers

652

(7)

Overview

653

(3)

Designing Your Tables

656

(1)

Configuring the Servers

657

(2)

Creating the View

659

(1)

Optimizing Query Performance

659

(6)

Understanding Indexes

660

(1)

Types of Indexes

661

(1)

Clustered Indexes

661

(2)

Nonclustered Indexes

663

(1)

Covering Indexes

664

(1)

Optimizing Database Performance with SQL Profiler

665

(8)

Exercise 1: Setting Up a Trace with SQL Profiler for the Northwind Database

667

(1)

Index Tuning Wizard

668

(1)

Exercise 2: Loading SQL Profiler trace file into the Index Tuning Wizard

668

(1)

SQL Query Analyzer

669

(1)

Tips for Writing Better Queries

669

(2)

Query Execution Plan

671

(2)

Optimizing Server Performance

673

(15)

Hardware Configuration

674

(1)

Processors

674

(1)

Memory

675

(1)

Disks

675

(3)

Software Configuration

678

(1)

SQL Server Settings

679

(3)

Windows 2000 Settings

682

(2)

Performance Monitor

684

(4)

Summary

688

(2)

FAQs

690

(5)

Index

695

Please wait while the item is added to your bag...

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Designing SQL Server 2000 Databases

Summary

Table of Contents

Supplemental Materials

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Designing SQL Server 2000 Databases

Summary

Table of Contents

Supplemental Materials

Digital License