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 ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
