Join Martin Guidry for an in-depth discussion in this video Planning compression, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- In this section, I'd like to talk about…compression in SQL Server 2012.…We'll look at two different techniques…of compressing data…and talk a little bit about how they work.…I've staged some code for you…in your exercise files.…So I'm gonna take all of this…and copy it into a new query.…The syntax is fairly straightforward.…We're going to alter a table,…the table called SalesOrderDetail.…And we see in line 5,…we're going to set the data compression…equal to none.…
So I'll go ahead and execute that.…Says, "Command(s) completed successfully."…Now let's go and look at the size…of SalesOrderDetail…so we have something to compare it to.…SalesOrderDetail,…I'll right-click and go to Properties.…And in the Storage section,…we see the compression is set to None…and the size right now is 9.641 megabytes,…so about nine and a half megabytes uncompressed.…Our first option with data compression…is to use row compression.…
And when we do row compression,…each row is compressed…by changing the amount of space…used to store each field.…
- 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?
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.