Microsoft SQL Server 2000 Unleashed,9780672319976

Microsoft SQL Server 2000 Unleashed

by ; ; ;
Edition: CD
ISBN13: 9780672319976
ISBN10: 0672319977
Format: Paperback
Pub. Date: 2001-12-01
Publisher(s): Sams
List Price: $59.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $61.60

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Microsoft® SQL Server 2000 Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This title includes topics such as: SQL Server and XML; high availability; SQL Server architecture; performance and tuning; SQL Server and the Web; scalability issues; integration with BackOffice and other Microsoft® products; enterprise issues; replication; Data Transformation Services (DTS); security; and analysis services. This book is written by authors who offer the benefits of their experiences to help readers understand and solve problems such as performance issues, implementing critical backup and recovery strategies, and code efficient applications that work across a variety of platforms and systems.

Table of Contents

Introduction 1(6)
Part I Welcome to Microsoft SQL Server 7(46)
The Microsoft SQL Server Environment
9(20)
SQL Server 2000 Environments and Editions
29(14)
What's New in SQL Server 2000
43(10)
Part II Installation and Upgrade 53(44)
Installing a New SQL Server Instance
55(20)
Client Installation and Configuration
75(22)
Part III SQL Server Administration Tasks and Tools 97(570)
SQL Server System and Database Administration
99(12)
SQL Server Enterprise Manager
111(28)
SQL Server Command-Line Utilities
139(16)
Creating and Managing Databases
155(20)
Creating and Managing Tables in SQL Server
175(24)
Creating and Managing Indexes
199(8)
Data Integrity
207(20)
Creating and Managing Views in SQL Server
227(16)
Creating and Managing Stored Procedures
243(86)
Creating and Managing Triggers
329(32)
User-Defined Functions
361(26)
Security and User Administration
387(22)
Database Backup and Recovery
409(40)
Database Maintenance
449(14)
SQL Server Scheduling and Notification
463(16)
Managing Linked and Remote Servers
479(26)
Importing and Exporting SQL Server Data Using BCP
505(40)
Importing and Exporting SQL Server Data Using Data Transformation Services (DTS)
545(24)
Administering Very Large SQL Server Databases
569(8)
Data Replication
577(60)
Defining SQL Server Environment and Naming Standards
637(30)
Part IV Transact-SQL 667(176)
Using Transact-SQL in SQL Server 2000
669(112)
Transaction Management and the Transaction Log
781(40)
Distributed Transaction Processing
821(22)
Part V SQL Server Internals and Performance Turning 843(444)
SQL Server Internals
845(106)
Indexes and Performance
951(48)
Understanding Query Optimization
999(62)
Query Analysis
1061(30)
Using the SQL Server Profiler
1091(26)
Using the SQL Debugger in Query Analyzer
1117(8)
Monitoring SQL Server Performance
1125(26)
Locking and Performance
1151(64)
Database Design and Performance
1215(40)
Configuring, Tuning, and Optimizing SQL Server Options
1255(32)
Part VI Integrating SQL Server into the Microsoft Architecture 1287(156)
SQL Mail
1289(26)
Using XML in SQL Server 2000
1315(32)
Microsoft SQL Server Analysis Services
1347(46)
Microsoft Transaction Server
1393(24)
SQL Server Clustering
1417(12)
Full Text Search
1429(14)
Index 1443

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.