Understanding Data Compression in SQL Server | Shaun Stuart | Skillshare

Understanding Data Compression in SQL Server

Shaun Stuart

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
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.

8

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Hello, I'm Shaun.

See full profile

Technology SQL Server Data Science
Report class