O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Real-World Database Layouts

Now that we’ve covered the fundamentals of databases, let’s pull all of the concepts together and apply them to define the structure of the databases for three applications—simple, moderately complex, and complex—given a fixed number of disk drives, a set of application characteristics, and a set of requirements.

Simple Application Workload

Scenario: In this scenario a user has a very simple application that utilizes a backend SQL Server 2005 database as a data repository for a small application. The maximum database size is estimated to be 8 GB with the data access somewhat evenly distributed across all the tables, with an average 95 percent read and 5 percent write data access ratio. The user would like to protect the ...

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