Join Martin Guidry for an in-depth discussion in this video Planning for partitioning, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, I'd like to talk about…using partitioning in SQL Server 2012.…Normally, a table exists entirely inside of one file group,…but we can use partitioning to split a table…into multiple file groups.…There's a few different reasons you'll do this.…The hypothetical we're gonna go through…in this exercise is that we've determined that…historical data is less important than our current data.…So, some of our different orders tables…have a long history of data.…
The most recent data is the most important to us.…We want the highest performance with that…and that data needs to be backed up the most often.…The old data is not as important to us…and also, old data doesn't change as often,…or doesn't change at all and therefore,…could be backed up less frequently.…So, by using partitioning,…we can take the data in these orders tables…and make sure that the newest data…is in the primary file group and the older data…is in a secondary file group.…
In order to do this,…we'll need to create a partition scheme…and a partition function.…
- 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.