Feeds

SQL Server and Scalability

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

  • alert
  • submit to reddit

Intelligent flash storage arrays

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.

Internet Security Threat Report 2014

More from The Register

next story
PEAK APPLE: iOS 8 is least popular Cupertino mobile OS in all of HUMAN HISTORY
'Nerd release' finally staggers past 50 per cent adoption
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
Yes, Virginia, there IS a W3C HTML5 standard – as of now, that is
You asked for it! You begged for it! Then you gave up! And now it's HERE!
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
prev story

Whitepapers

Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Top 5 reasons to deploy VMware with Tegile
Data demand and the rise of virtualization is challenging IT teams to deliver storage performance, scalability and capacity that can keep up, while maximizing efficiency.
How to simplify SSL certificate management
Simple steps to take control of SSL certificates across the enterprise, and recommendations centralizing certificate management throughout their lifecycle.