Understanding Data Compression in SQL Server | Shaun Stuart | Skillshare

Warning: Skillshare uses Javascript for some of its core functionality. It is highly recommended that you turn on Javascript in your preferences and reload the page.

Understanding Data Compression in SQL Server

Shaun Stuart

11 Videos (1h 19m)

- Introduction To Understanding Data Compression In SQL Server
  
  0:49
- Data Compression: What It Is And What It Is Not
  
  3:17
- How SQL Server Stores Data
  
  9:26
- Two Different Types Of Data Compression
  
  1:05
- Row Compression - How It Works
  
  3:51
- Page Compression - How It Works
  
  7:30
- When Does Compression Take Place?
  
  2:04
- Turning Data Compression On And Off
  
  2:38
- Data Compression Demos
  
  21:07
- Compression Pitfalls
  
  6:52
- Demo: How To Find And Compress Newly Created Objects
  
  20:40

About This Class

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

To run the included scripts, a copy of SQL Server 2008 or higher, Enterprise, Developer, or Evaluation edition is required.

Class Projects See All

The files here containing the T-SQL code used in the two demo videos. Feel free to play with these and see how they work.

No projects have
been added yet

No projects have
been added yet

No projects have
been added yet

No projects have
been added yet

3

Students

--

Projects

0

Reviews (0)

Shaun Stuart

Hello, I'm Shaun.

See full profile

Skills in this Class:

Technology SQL Server Data Science