{"id":3121,"date":"2016-02-04T13:01:57","date_gmt":"2016-02-04T13:01:57","guid":{"rendered":"http:\/\/sysinfotools.com\/blog\/?p=3121"},"modified":"2024-12-30T07:42:32","modified_gmt":"2024-12-30T07:42:32","slug":"types-of-sql-server-compression","status":"publish","type":"post","link":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/","title":{"rendered":"3 Types of Compression in SQL Server"},"content":{"rendered":"<div class=\"block_sum\"><strong>Summary:-<\/strong> Here you can explore the type of compression you can make in the SQL server. We will discuss the three types of SQL Database Compression that you can do. But if you face any type of error while compressing the SQL Database then you can use the <a href=\"https:\/\/www.sysinfotools.com\/recovery\/ms-sql-database-recovery.php\"><strong>SQL Database Recovery<\/strong><\/a> Utility to fix such errors and corruption issues.<\/p>\n<p class=\"blog-btn\"><a class=\"sum-d-btn\" href=\"https:\/\/www.sysinfotools.com\/demo-version\/SysInfoTools-MS-SQL-Database-Recovery.exe\"><i class=\"icon-windows\"><\/i>  Download<\/a>   <a class=\"sum-b-btn\" href=\"https:\/\/www.sysinfotools.com\/buynow\/ms-sql-database-recovery.php\"><i class=\"icon icon-basket\"><\/i>  Buy Now<\/a><\/p>\n<\/div>\n<p>Microsoft SQL Server supports different compression types for tables and indexes, and also supports archival compression for them. The data compression feature in SQL Server is very helpful in reducing the size of the database file. Being an intensive workload because of the heavy storage of data. Data compression in SQL Server helps to improve the performance of I\/O.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<div class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/div>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#Different_types_of_SQL_Server_Compression\" >Different types of SQL Server Compression<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#ROW-Level_Compression\" >ROW-Level Compression<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#PAGE-Level_Compression\" >PAGE-Level Compression\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#Row_Compression\" >Row Compression<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#Prefix_Compression\" >Prefix Compression<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#Dictionary_Compression\" >Dictionary Compression<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#Unicode_Compression\" >Unicode Compression\u00a0<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Different_types_of_SQL_Server_Compression\"><\/span>Different types of SQL Server Compression<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are three major compressions used in MS SQL Database and you can go through all of them.<\/p>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ROW-Level_Compression\"><\/span>ROW-Level Compression<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Non-leaf levels of pages in the database use ROW-level compression. Data rows are put on the page serial-wise, starting immediately after the header. The maximum amount of data and overhead contained in a single row on a page is 8,060 bytes (8 KB). However, this does not include the data stored in the Text\/Image page type. When the total row size of all fixed and variable columns in a table exceeds the 8,060-byte limitation, SQL Server dynamically moves one or more variable-length columns to pages in the ROW_OVERFLOW_DATA allocation unit, starting from the column with the largest width.<\/p>\n<p><em>When Row-level compression takes place: <\/em><\/p>\n<ul>\n<li>It reduces the metadata overhead that is associated with the record.<\/li>\n<li>Uses a variable-length storage format for numeric types (for example integer, decimal, and float) and the types that are based on numeric (for example date &amp; time and money).<\/li>\n<li>It stores fixed character strings by using a variable-length format by not storing the blank characters.<\/li>\n<\/ul>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"PAGE-Level_Compression\"><\/span>PAGE-Level Compression\u00a0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Page compression consists of three different operations in the following order:<\/p>\n<ol>\n<li>Row Compression<\/li>\n<li>Prefix Compression<\/li>\n<li>Dictionary Compression<\/li>\n<\/ol>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Row_Compression\"><\/span>Row Compression<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When you use page compression, non-leaf level pages of indexes are compressed by using only Row compression.<\/p>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Prefix_Compression\"><\/span>Prefix Compression<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For each page that is being compressed, prefix compression uses the following steps:<\/p>\n<ul>\n<li>For each column, a value is identified that can be used to reduce the storage space for the values in each column.<\/li>\n<li>A row that represents the prefix values for each column is created and stored in the compression information (CI) structure that immediately follows the page header.<\/li>\n<li>The repeated prefix values in the column are replaced by a reference to the corresponding prefix. If the value in a row does not exactly match the selected prefix value, a partial match can still be indicated.<\/li>\n<\/ul>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Dictionary_Compression\"><\/span>Dictionary Compression<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>After prefix compression has been completed, dictionary compression is applied to the database. Dictionary compression searches for repeated values anywhere on the page and stores them in the CI area. Unlike prefix compression, dictionary compression is not restricted to one column. Dictionary compression can replace repeated values that occur anywhere on a page.<\/p>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Unicode_Compression\"><\/span>Unicode Compression\u00a0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>SQL server compresses Unicode values that are stored in a row or page-compressed objects. The Database Engine stores Unicode data as 2 bytes, regardless of locale. This is known as UCS-2 encoding. Unicode compression supports the fixed-length <strong>nchar (n<\/strong>) and <strong>nvarchar (n)<\/strong> data types. Data values that are stored off-row or in <strong>nvarchar (max)<\/strong> columns are not compressed with Unicode compression.<\/p>\n<h4 class=\"wp-block-heading\">Conclusion<\/h4>\n<p>You have seen that there are three types of compression in SQL Server and they are Row Compression, Page Compression, and Unicode Compression. But you cannot compress the SQL Database if it is corrupted or damaged. Therefore, to fix the corruptions, you can use the SQL Database Recovery Software. After <a href=\"https:\/\/www.sysinfotools.com\/blog\/repair-master-database-sql-server\/\">repairing the Master SQL Database<\/a>, you can easily compress your database.<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;3121&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;3 Types of Compression in SQL Server&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary:- Here you can explore the type of compression you can make in the SQL server. We will discuss the<a class=\"read-more ml-1 main-read-more\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":7744,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1420],"tags":[],"class_list":["post-3121","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-database-recovery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>3 Types of Compression in SQL Server<\/title>\n<meta name=\"description\" content=\"Know all about SQL Server Compression and how it is useful for an SQL database. Explore the types of compression in SQL Server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Types of Compression in SQL Server\" \/>\n<meta property=\"og:description\" content=\"Know all about SQL Server Compression and how it is useful for an SQL database. Explore the types of compression in SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\" \/>\n<meta property=\"og:site_name\" content=\"SysinfoTools Tech Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sysinfotools\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-04T13:01:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-30T07:42:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Simran Bhatia\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simran Bhatia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\"},\"author\":{\"name\":\"Simran Bhatia\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a\"},\"headline\":\"3 Types of Compression in SQL Server\",\"datePublished\":\"2016-02-04T13:01:57+00:00\",\"dateModified\":\"2024-12-30T07:42:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\"},\"wordCount\":632,\"publisher\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png\",\"articleSection\":[\"SQL Database Recovery\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\",\"name\":\"3 Types of Compression in SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png\",\"datePublished\":\"2016-02-04T13:01:57+00:00\",\"dateModified\":\"2024-12-30T07:42:32+00:00\",\"description\":\"Know all about SQL Server Compression and how it is useful for an SQL database. Explore the types of compression in SQL Server.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png\",\"contentUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png\",\"width\":698,\"height\":400,\"caption\":\"Types-of-SQL-Server-Compression\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sysinfotools.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 Types of Compression in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#website\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/\",\"name\":\"SysinfoTools Tech Blog\",\"description\":\"Overview of Trending Technology Issues and Challenges\",\"publisher\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sysinfotools.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#organization\",\"name\":\"SysinfoTools\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp\",\"contentUrl\":\"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp\",\"width\":235,\"height\":61,\"caption\":\"SysinfoTools\"},\"image\":{\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/sysinfotools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a\",\"name\":\"Simran Bhatia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g\",\"caption\":\"Simran Bhatia\"},\"description\":\"Simran Bhatia is a technical content writer engaged in writing clear, concise, and SEO-optimized content. With a background in computer science and a passion for writing, I thrive to deliver complex technical content in simple layman terms.\",\"sameAs\":[\"https:\/\/www.sysinfotools.com\/\",\"https:\/\/www.linkedin.com\/in\/simran-bhatia-190169299\"],\"url\":\"https:\/\/www.sysinfotools.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 Types of Compression in SQL Server","description":"Know all about SQL Server Compression and how it is useful for an SQL database. Explore the types of compression in SQL Server.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/","og_locale":"en_US","og_type":"article","og_title":"3 Types of Compression in SQL Server","og_description":"Know all about SQL Server Compression and how it is useful for an SQL database. Explore the types of compression in SQL Server.","og_url":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/","og_site_name":"SysinfoTools Tech Blog","article_publisher":"https:\/\/www.facebook.com\/sysinfotools","article_published_time":"2016-02-04T13:01:57+00:00","article_modified_time":"2024-12-30T07:42:32+00:00","og_image":[{"width":698,"height":400,"url":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png","type":"image\/png"}],"author":"Simran Bhatia","twitter_misc":{"Written by":"Simran Bhatia","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#article","isPartOf":{"@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/"},"author":{"name":"Simran Bhatia","@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a"},"headline":"3 Types of Compression in SQL Server","datePublished":"2016-02-04T13:01:57+00:00","dateModified":"2024-12-30T07:42:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/"},"wordCount":632,"publisher":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png","articleSection":["SQL Database Recovery"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/","url":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/","name":"3 Types of Compression in SQL Server","isPartOf":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage"},"image":{"@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png","datePublished":"2016-02-04T13:01:57+00:00","dateModified":"2024-12-30T07:42:32+00:00","description":"Know all about SQL Server Compression and how it is useful for an SQL database. Explore the types of compression in SQL Server.","breadcrumb":{"@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#primaryimage","url":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png","contentUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2016\/02\/Types-of-SQL-Server-Compression-Used-for-MDF-Database.png","width":698,"height":400,"caption":"Types-of-SQL-Server-Compression"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sysinfotools.com\/blog\/types-of-sql-server-compression\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sysinfotools.com\/blog\/"},{"@type":"ListItem","position":2,"name":"3 Types of Compression in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.sysinfotools.com\/blog\/#website","url":"https:\/\/www.sysinfotools.com\/blog\/","name":"SysinfoTools Tech Blog","description":"Overview of Trending Technology Issues and Challenges","publisher":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sysinfotools.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.sysinfotools.com\/blog\/#organization","name":"SysinfoTools","url":"https:\/\/www.sysinfotools.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp","contentUrl":"https:\/\/www.sysinfotools.com\/blog\/wp-content\/uploads\/2024\/07\/logo-new.webp","width":235,"height":61,"caption":"SysinfoTools"},"image":{"@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/sysinfotools"]},{"@type":"Person","@id":"https:\/\/www.sysinfotools.com\/blog\/#\/schema\/person\/0bc86a610ba204e43dcf67ac0c4f422a","name":"Simran Bhatia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/640214467911604daca4d8657c68321260a2bb37049f372d203fa8fe6218dc5d?s=96&r=g","caption":"Simran Bhatia"},"description":"Simran Bhatia is a technical content writer engaged in writing clear, concise, and SEO-optimized content. With a background in computer science and a passion for writing, I thrive to deliver complex technical content in simple layman terms.","sameAs":["https:\/\/www.sysinfotools.com\/","https:\/\/www.linkedin.com\/in\/simran-bhatia-190169299"],"url":"https:\/\/www.sysinfotools.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts\/3121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/comments?post=3121"}],"version-history":[{"count":15,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts\/3121\/revisions"}],"predecessor-version":[{"id":15719,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/posts\/3121\/revisions\/15719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/media\/7744"}],"wp:attachment":[{"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/media?parent=3121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/categories?post=3121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sysinfotools.com\/blog\/wp-json\/wp\/v2\/tags?post=3121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}