From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Compress data tables - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Compress data tables
- [Instructor] Now that we know about some of the logic behind how data compression is applied let's see if we can squeeze out any gains from the Wide World Importers database. First, I want to make sure that the Wide World Importers database is the active database. So, I'll go ahead and run or execute lines one through two. Then we can view the compression settings for our different objects in the database by running this select statement. It's going to pull information out from a variety of system tables. So, go ahead and highlight lines five through 13 and press execute. That'll show up a results window down below where we can see the schema name and object name for all the different objects within our database. If we want to compare those to the actual database go over to the databases folder in object explorer, expand Wide World Importers and then expand tables and we'll see that the schema and table names here…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.