O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

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

How SQL Server 2000 Stores Data

SQL Server stores the dataof every database in one or more data files. These files are stored directly on the hard disk and are treated like other operating system files; however, SQL Server locks them as soon as it opens a database.

It is inside the data files thatSQL Server stores tables and indexes, as well as a definition of everyobject in the database. Properties of objects are stored in the database, too. Every database is almost self contained, so it can be easily moved to another server if required.

Accessing the hard disk every timea user wants to retrieve some information, such as a product's price, is inefficient. To read information from disk, the hard disk heads must physically move to access specific ...

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