The Register® — Biting the hand that feeds IT

SQL Server and Scalability

Is SQL Server 2005 truly scalable? Can it really run big databases?

Understand how application security is evolving

Well, I’m convinced. The enterprise edition can, within the constraints of the operating system, run databases of unlimited size than use unlimited RAM on any number of CPUs. It supports 64-bit operation, partitioning and parallel index operations.

Still smarting under its history, Microsoft has put together a range of impressive case studies, which involve large databases that went operational on the beta of SQL Server 2005. In addition, Microsoft has been using the database engine, for real, on more than 65 of its own, internal, applications.

Paul Flessner, SVP at Microsoft, says:

In addition to running the full SAP, payroll, expense, tax data warehouse, and document repository systems, Microsoft now has more than 10 instances of SQL Server 2005 that are storing multiple terabytes of data. These SQL Server 2005 installations have been responsible for processing more than 7 billion, yes billion, transactions against our SAP system SQL Server 2005 database, which includes processing close to 3 million invoices and over 1.6 million sales orders

Return to Page 1 of main article here - otherwise use "back" button.

Tune into our application security webcast, click here

Don’t Miss

GoogleGoogle code cloud punts on-demand embarrassment

Fail and You Mountain View's Sarah Palin moment

open source 75Microsoft weighs next-phase in open-source support

Spring, PHP, and Apache sized up

iTunes logoiTunes minus the player: hack your Apple beats

Mac Secrets Dodge the shareware sledgehammer

OracleOracle plans cloud strategy

Exclusive Larry smells money in madness