{"id":11275,"date":"2019-04-03T20:11:57","date_gmt":"2019-04-03T20:11:57","guid":{"rendered":"https:\/\/dbtut.com\/?p=11275"},"modified":"2019-04-03T20:11:58","modified_gmt":"2019-04-03T20:11:58","slug":"what-is-partitioned-view-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/","title":{"rendered":"What is Partitioned View in SQL Server"},"content":{"rendered":"<p>As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create Partition On SQL Server<\/a>&#8220;.<\/p>\n<p>In versions prior to SQL Server 2016, Table Partitioning was not supported in Standard Edition. Therefore, organizations that use Standard Edition could not do table partitioning. Instead, Partitioned View can solve this problem partially. If you are using a version of SQL Server 2016 and later, I recommend that you use table partition instead of partitioned view if your infrastructure is appropriate.<\/p>\n<h2>Example<\/h2>\n<p>We create 12 tables as follows and we add a record to every table as follows. To be able to do Partitioned View, there must be CHECK constraint on the column that will be partitioned. You may want to read my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/how-to-create-check-constraint\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create CHECK CONSTRAINT<\/a>&#8220;.<\/p>\n<pre class=\"lang:default decode:true \">CREATE TABLE TableJanuary\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 1),\n\t  CONSTRAINT [PK_TableJanuary] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableFebruary\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 2),\n\t  CONSTRAINT [PK_TableFebruary] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableMarch\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 3),\n\t  CONSTRAINT [PK_TableMarch] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableApril\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 4),\n\t  CONSTRAINT [PK_TableApril] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableMay\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 5),\n\t  CONSTRAINT [PK_TableMay] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableJune\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 6),\n\t  CONSTRAINT [PK_TableJune] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableJuly\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 7),\n\t  CONSTRAINT [PK_TableJuly] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableAugust\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 8),\n\t  CONSTRAINT [PK_TableAugust] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableSeptember\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 9),\n\t  CONSTRAINT [PK_TableSeptember] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableOctober\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 10),\n\t  CONSTRAINT [PK_TableOctober] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableNovember\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 11),\n\t  CONSTRAINT [PK_TableNovember] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nCREATE TABLE TableDecember\n   (ID      INT,\n   CustomerID      INT      NOT NULL,\n   OrderMonth      INT      NULL\n      CHECK (OrderMonth = 12),\n\t  CONSTRAINT [PK_TableDecember] PRIMARY KEY CLUSTERED ([ID] ASC)\n   )\nGO\nINSERT INTO [dbo].[TableJanuary]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,1)\nINSERT INTO [dbo].[TableFebruary]([ID],[CustomerID],[OrderMonth]) VALUES (1,314,2)\nINSERT INTO [dbo].[TableMarch]([ID],[CustomerID],[OrderMonth]) VALUES (1,314,3)\nINSERT INTO [dbo].[TableApril]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,4)\nINSERT INTO [dbo].[TableMay]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,5)\nINSERT INTO [dbo].[TableJune]([ID],[CustomerID],[OrderMonth]) VALUES (1,314,6)\nINSERT INTO [dbo].[TableJuly]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,7)\nINSERT INTO [dbo].[TableAugust]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,8)\nINSERT INTO [dbo].[TableSeptember]([ID],[CustomerID],[OrderMonth]) VALUES (1,314,9)\nINSERT INTO [dbo].[TableOctober]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,10)\nINSERT INTO [dbo].[TableNovember]([ID],[CustomerID],[OrderMonth]) VALUES (1,314,11)\nINSERT INTO [dbo].[TableDecember]([ID],[CustomerID],[OrderMonth]) VALUES (1,324,12)\n<\/pre>\n<p>We create partitioned view with the help of the following script.<\/p>\n<pre class=\"lang:default decode:true\">CREATE VIEW PartitionedViewExample\nAS\nSELECT * FROM TableJanuary\nUNION ALL\nSELECT * FROM TableFebruary\nUNION ALL\nSELECT * FROM TableMarch\nUNION ALL\nSELECT * FROM TableApril\nUNION ALL\nSELECT * FROM TableMay\nUNION ALL\nSELECT * FROM TableJune\nUNION ALL\nSELECT * FROM TableJuly\nUNION ALL\nSELECT * FROM TableAugust\nUNION ALL\nSELECT * FROM TableSeptember\nUNION ALL\nSELECT * FROM TableOctober\nUNION ALL\nSELECT * FROM TableNovember\nUNION ALL\nSELECT * FROM TableDecember<\/pre>\n<p>We can use partitioned view with the help of the following query.<\/p>\n<pre class=\"lang:default decode:true \">SELECT * FROM PartitionedViewExample\nWHERE OrderMonth IN (5,6)\n<\/pre>\n<p>As you can see in the screenshot below, when we use the OrderMonth column as a filter, it goes to only two tables.<\/p>\n<p id=\"QkUxvaZ\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-11280  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/img_5ca464f152d1e.png\" alt=\"\" width=\"775\" height=\"410\"><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11275\" class=\"pvc_stats all  \" data-element-id=\"11275\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article &#8220;How To Create Partition On SQL Server&#8220;. In versions prior to SQL Server 2016, Table Partitioning was not supported in Standard Edition. Therefore, organizations that use Standard Edition could not do table partitioning. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11275\" class=\"pvc_stats all  \" data-element-id=\"11275\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":11281,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[3043,3044,3042],"class_list":["post-11275","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-partitioned-view-in-sql-server","tag-what-can-i-use-instead-of-partition-in-sql-server","tag-what-is-partitioned-view"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":214,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is Partitioned View in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"What is Partitioned View 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:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Partitioned View in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is Partitioned View in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-03T20:11:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-03T20:11:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"479\" \/>\n\t<meta property=\"og:image:height\" content=\"308\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is Partitioned View in SQL Server\",\"datePublished\":\"2019-04-03T20:11:57+00:00\",\"dateModified\":\"2019-04-03T20:11:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\"},\"wordCount\":192,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png\",\"keywords\":[\"Partitioned view in sql server\",\"what can I use instead of partition in SQL Server\",\"What is Partitioned View\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\",\"name\":\"What is Partitioned View in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png\",\"datePublished\":\"2019-04-03T20:11:57+00:00\",\"dateModified\":\"2019-04-03T20:11:58+00:00\",\"description\":\"What is Partitioned View in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png\",\"width\":479,\"height\":308},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Partitioned View in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Partitioned View in SQL Server - Database Tutorials","description":"What is Partitioned View 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:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"What is Partitioned View in SQL Server - Database Tutorials","og_description":"What is Partitioned View in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-03T20:11:57+00:00","article_modified_time":"2019-04-03T20:11:58+00:00","og_image":[{"width":479,"height":308,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is Partitioned View in SQL Server","datePublished":"2019-04-03T20:11:57+00:00","dateModified":"2019-04-03T20:11:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/"},"wordCount":192,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png","keywords":["Partitioned view in sql server","what can I use instead of partition in SQL Server","What is Partitioned View"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/","name":"What is Partitioned View in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png","datePublished":"2019-04-03T20:11:57+00:00","dateModified":"2019-04-03T20:11:58+00:00","description":"What is Partitioned View in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-3.png","width":479,"height":308},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/03\/what-is-partitioned-view-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is Partitioned View in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11275"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11275\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11281"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}