Microsoft SQL Server 2000 Administrator's Companion with CD-ROM

Overview

This title is the definitive daily operations guide to planning, deploying, and maintaining Microsoft SQL Server 2000. With it, administrators learn how to use this scalable, high-performance relational database management system to solve complex business challenges, launch Internet-based solutions, and lower the cost and complexity of distributed database solutions. This comprehensive reference introduces new features of both SQL Server 2000 and the Microsoft Windows 2000 operating system. And it includes an ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (2) from $5.99   
  • Used (16) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$5.99
Seller since 2008

Feedback rating:

(94)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2000 Paperback New Ships Fast! Satisfaction Guaranteed!

Ships from: Skokie, IL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2014

Feedback rating:

(178)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

This title is the definitive daily operations guide to planning, deploying, and maintaining Microsoft SQL Server 2000. With it, administrators learn how to use this scalable, high-performance relational database management system to solve complex business challenges, launch Internet-based solutions, and lower the cost and complexity of distributed database solutions. This comprehensive reference introduces new features of both SQL Server 2000 and the Microsoft Windows 2000 operating system. And it includes an expanded section covering installation and setup, an example-rich segment on how to use SQL Server 2000 to create and modify databases, and information about built-in features such as DTC, MTS, and OLAP services. It's the essential daily operations guide for the SQL Server database administrator!


Deploy, administer, and support SQL Server 2000 in any organization with this practical guide.

Read More Show Less

Editorial Reviews

Booknews
This guide provides the facts needed to deploy, administer, and support SQL Server 2000 in organizations of any size. Using a hands-on, example-rich approach, it gives peer advice, product information, detailed procedures, and real-world troubleshooting tips from experienced professionals (Garcia, Jamie Reding, Edward Whalen, and Steve Adrien DeLuca). Topics include preparing for installation, installing and configuring, using services and features, built-in server features, and how to manage, tune, maintain, and troubleshoot. The included CD-ROM contains a fully searchable electronic copy of the text, and white papers to help deploy the program. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780735610514
  • Publisher: Microsoft Press
  • Publication date: 10/27/2000
  • Series: Administrator's Companion Series
  • Edition description: BK&CD-ROM
  • Pages: 900
  • Product dimensions: 7.56 (w) x 9.44 (h) x 2.12 (d)

Meet the Author


Marcilina Garcia is a senior consultant at Performance Tuning Corporation, where she specializes in database performance benchmarks, SQL Server performance and database design, and system configuration. She is a coauthor of Microsoft SQL Server 7 Administrator's Companion and Microsoft SQL Server 7.0 Performance Tuning Technical Reference.

Edward Whalen is president of Performance Tuning Corporation, where he specializes in database performance, administration, and backup/ recovery solutions. He is a coauthor of Microsoft SQL Server 7.0 Administrator's Companion and Microsoft SQL Server 7.0 Performance Tuning Technical Reference, as well as Oracle Performance Tuning and Optimization, and Teach Yourself Oracle in 28 Days.

Jamie Reding has 15 years of experience in networking and system performance at IBM and Compaq Computer Corporation. He is now a performance engineer on the Microsoft SQL Server team. He has participated and consulted on numerous TPC-C benchmarks and has extensive experience in the performance of system hardware, Microsoft Windows NT, and database systems.

Read More Show Less

Table of Contents


Chapter 1: Overview of Microsoft SQL Server 2000 ..... 2
Chapter 2: The Microsoft Windows 2000 Platform ..... 14
Chapter 3: Roles and Responsibilities of the Microsoft SQL Server DBA ..... 34
Chapter 4: Designing a Microsoft SQL Server System ..... 54
Chapter 5: I/0 Subsystem Configuration and Planning ..... 70
Chapter 6: Capacity Planning ..... 104
Chapter 7: Installing Microsoft SQL Server ..... 144
Chapter 8: Managing Microsoft SQL Server Services ..... 162
Chapter 9: Creating Databases ..... 178
Chapter 10: Creating Database Tables ..... 204
Chapter 11: Configuring Microsoft SQL Server on the Network ..... 228
Chapter 12: Microsoft SQL Server and Microsoft Cluster Services ..... 248
Chapter 13: Introduction to Transact-SQL and SQL Query Analyzer ..... 276
Chapter 14: Retrieving Data Using Transact-SQL ..... 292
Chapter 15: Managing Tables Using Transact-SQL and Enterprise Manager ..... 334
Chapter 16: Creating and Using Defaults, Constraints, and Rules ..... 356
Chapter 17: Creating and Using Indexes ..... 398
Chapter 18: Creating and Using Views ..... 434
Chapter 19: Understanding Transactions and Transaction Locking ..... 466
Chapter 20:Understanding Advanced T-SQL ..... 492
Chapter 21: Creating and Managing Stored Procedures ..... 512
Chapter 22: Creating and Using Triggers ..... 540
Chapter 23: Accessing Microsoft SQL Server from the Internet ..... 568
Chapter 24: Loading the Database ..... 578
Chapter 25: Component Services and Microsoft Distributed Transaction Coordinator ..... 616
Chapter 26: Microsoft SQL Server Replication: Overview and Snapshot Replication ..... 634
Chapter 27: Transactional Replication ..... 694
Chapter 28: Merge Replication ..... 738
Chapter 29: Using Microsoft SQL Server Analysis Services ..... 770
Chapter 30: Microsoft SQL Server Administration ..... 808
Chapter 31: Automating Administrative Tasks ..... 836
Chapter 32: Backing Up Microsoft SQL Server ..... 872
Chapter 33: Restoring and Recovering the Database ..... 910
Chapter 34: User and Security Management ..... 926
Chapter 35: Using SQL Query Analyzer and SQL Profiler ..... 958
Chapter 36: Solving Common Performance Problems ..... 986
Appendix A: Microsoft SQL Server Configuration Parameters ..... 1012
Appendix B: Microsoft SQL Server Monitoring ..... 1030
Appendix C: DBCC Commands ..... 1042
Glossary ..... 1047
Index ..... 1063
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)