Understanding Data Compression In SQL Server

An exploration of how SQL Server implements data compression, how it can help improve performance, & how to implement it
4.4 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
92 students enrolled
Instructed by Shaun Stuart Development / Databases
67% off
Take This Course
  • Lectures 12
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2013 English

Course Description

This course explains how SQL Server implements data compression, how it can improve performance, reduce disk space, and shows how it can be implemented. It provides sample scripts and demonstrations of the process.

The course will take about 1.5 hours to complete. It consists of videos and video demos. It also includes T-SQL scripts you can download for use on your own systems.

The course is intended for database administrators with an intermediate-level knowledge of SQL Server 2008, 2008 R2, or 2012.

What are the requirements?

  • To run the included scripts, a copy of SQL Server 2008 or higher, Enterprise, Developer, or Evaluation edition is required
  • Basic knowledge of T-SQL is helpful, but not required

What am I going to get from this course?

  • Over an hour of content!
  • By the end of this course, you will know how SQL Server data compression operates and how to implement it

Who is the target audience?

  • Advanced beginner to intermediate level DBAs
  • Anyone interested in learning more about how SQL Server Data Compression works

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction
Section 2: Database Compression Overview

An overview of what SQL Server's Data Compression is, what it is not, and where it can provide the most benefit.

Section 3: SQL Server Storage Internals

A brief look at how SQL Server stores data internally, without compression.

Section 4: Types Of Data Compression

SQL Server implements two different types of compression algorithms.

Section 5: Data Compression Methodologies

A look at how row compression operates.


A look at how page compression operates.

Section 6: Working With Data Compression

A discussion on when SQL Server performs data compression and how that affects system performance.


A discussion of the various ways data compression can be turned on and off.

Section 7: Data Compression Demos

Several demos of turning data compression on and off, row versus page compression, and an example of SQL Server switching from row to page compression.

Section 8: Compression Pitfalls

Things to watch out for when implementing data compression.

Section 9: New Object Compression Demo

A demonstration of a script you can use to automatically find and compress newly created objects in multiple databases.

Section 10: Wrap Up

A summary of what this course was taught you.

10 questions

This quiz will test how well you understand the important concepts discussed in this course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shaun Stuart, Senior SQL Server Database Administrator And Author

Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.

Ready to start learning?
Take This Course