Join Martin Guidry for an in-depth discussion in this video Understanding files and filegroups, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, we're going to talk about…data files in SQL Server 2012.…There are three types of files available to us.…The first is a Transaction Log file.…Then we have Primary Data files.…And Secondary Data files.…And we'll talk about each of these individually.…The Transaction Log holds a record…of all transactions in the system,…so any time data is changed in any way…information is written to the transaction log…to keep track of those changes.…
Transaction log files always have an LDF extension.…Best practices say we should not…put the transaction log on the same drive as our data files.…We can typically see a fairly significant…performance increase by separating…data files from transaction log files.…There are many activities in SQL Server…that will cause both the data file…and the transaction log files to be written to,…if all of these files are on the same drive,…then we'll have a bottleneck there.…
But if the files are on different drives,…the server can typically write to both files…at the same time, giving a performance increase.…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.