O'Reilly logo

Designing SQL Server 2000 Databases by Syngress

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3

SQL Server Scalability and Availability

Solutions in this chapter:

 Scaling Up vs. Scaling Out

 SQL Server Fail-Over Clustering

 Distributed Partitioned Views

 Log Shipping

 Indexed Views

Introduction

Every technology professional has faced issues concerning the availability and scalability of his or her hardware and software solutions. Continued commitment to making SQL Server a player in all markets, from handheld and portable applications to enterprise-scale database solutions, is evident in SQL Server 2000. This latest release of SQL Server provides support for up to 64GB of RAM and 32 processors, with Enterprise Edition running on Windows 2000 Datacenter Server. At the other end of the spectrum, SQL Server now boasts support for database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required