From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Physical database design

Physical database design - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial

Physical database design

“

- [Instructor] Even though we talk about SQL Server as a complete solution for storing your data, when it comes down to it, it's nothing more than a bunch of files stored in a disk that are being managed by the system. With some attention given to how those files are stored and where they're located, you can maximize your available resources. Let's talk, for a moment, about the physical design of the database. SQL Serveer databases are made up of a minimum of two files, a data file ending in the mdf file extension and a log file ending in ldf. The data file contains the current state of all of the data, tables, and other objects within the database. The log file contains all of the transaction information for how the database got to its current state. If a value is updated in a table, the data file will store the resulting change, while the log file stores the information about when the change occurred, who initiated it, and what the change was. By having detailed log information, you…

Contents