{"id":9195,"date":"2022-08-01T07:17:00","date_gmt":"2022-08-01T05:17:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=9195"},"modified":"2023-03-02T12:49:14","modified_gmt":"2023-03-02T11:49:14","slug":"create-sql-server-partitioned-views","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/","title":{"rendered":"Create SQL Server partitioned views to group tables having partitions"},"content":{"rendered":"\n<p>How to Create SQL Server partitioned views to group data from multiple tables? Find examples of scripts to create views that points to four or more different tables. In this example, each Sales table would contain the sales of a year, a quarter, or a month, to optimize performance.<\/p>\n\n\n\n<p>First, what is a partitioned view? A partitioned view joins horizontally the partitioned data of a set of tables. These tables can be on one or multiple physical servers. SQL Server partitioned views allows to group data from tables and displays it as if it came from a unique source table. A view that joins together data from tables on the same SQL Server instance is called a <strong><em>local partitioned view<\/em><\/strong>.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/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:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#first-create-the-tables-and-the-partitions\" >First create the tables and the partitions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#create-yearly-partitioned-views-with-a-t-sql-script\" >Create yearly partitioned views with a T-SQL script<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#quarterly-horizontal-partitioned-sql-server-views\" >Quarterly horizontal partitioned SQL Server views<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#monthly-horizontal-partitioning-of-a-sql-server-view\" >Monthly horizontal partitioning of a SQL Server view<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"first-create-the-tables-and-the-partitions\"><\/span>First create the tables and the partitions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To use the partitioned views, you need underlying tables that are physically partitioned. Here is a tutorial on how to create the partitions and the tables to be used by the views. Adapt the code to every scenario.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"9pzsRdEFfQ\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partition\/\">Create a SQL Server partition<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Create a SQL Server partition&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partition\/embed\/#?secret=N1WAl8HRLj#?secret=9pzsRdEFfQ\" data-secret=\"9pzsRdEFfQ\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"create-yearly-partitioned-views-with-a-t-sql-script\"><\/span>Create yearly partitioned views with a T-SQL script<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This is a <a href=\"https:\/\/www.vocabulary.com\/dictionary\/computer%20code\" target=\"_blank\" rel=\"noreferrer noopener\">code<\/a> example of a horizontally partitioned view. It is also a local view because all data is stored on the same database server. The underlying tables are called the view&#8217;s member tables. However, a widely used model is partitioning by years. This is because past years are rarely, if ever, used, which greatly improves performance when querying the current year&#8217;s data. For example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the Year 2019 and past: SALES_2019<\/li>\n\n\n\n<li>Year 2020: SALES_2020<\/li>\n\n\n\n<li>Year 2021: SALES_2021<\/li>\n\n\n\n<li>Finally, the year 2022 and future: SALES_2022<\/li>\n<\/ul>\n\n\n\n<p>However, this annual partitioning implies managing the insertion of data dynamically on the appropriate year according to the effective date of the data concerned.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE VIEW [dbo].[V_Sales]\nAS \n  SELECT [Year], [Month], [CustomerID], [SalesID], [Amount_ET], [Amount_IT]\n  FROM [dbo].[Sales_2019]\n  UNION ALL \n  SELECT [Year], [Month], [CustomerID], [SalesID], [Amount_ET], [Amount_IT]\n  FROM [dbo].[Sales_2020]\n  UNION ALL \n  SELECT [Year], [Month], [CustomerID], [SalesID], [Amount_ET], [Amount_IT]\n  FROM [dbo].[Sales_2021]\n  UNION ALL \n  SELECT [Year], [Month], [CustomerID], [SalesID], [Amount_ET], [Amount_IT]\n  FROM [dbo].[Sales_2022]\n;\nGO<\/pre>\n\n\n\n<p>Moreover, example uses four sales tables with each one containing only one year of data. Indeed, the view displays data from year 2019 to 2022. Please note that to ensure the tables data integrity, it&#8217;s better to add constraint to each table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"quarterly-horizontal-partitioned-sql-server-views\"><\/span>Quarterly horizontal partitioned SQL Server views<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Or a partitioning of the sales figures by quarter:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>First quarter : SALES_Q1<\/li>\n\n\n\n<li>Second quarter : SALES_Q2<\/li>\n\n\n\n<li>Third quarter : SALES_Q3<\/li>\n\n\n\n<li>Fourth quarter : SALES_Q4<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"monthly-horizontal-partitioning-of-a-sql-server-view\"><\/span>Monthly horizontal partitioning of a SQL Server view<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In fact, to go to the end of the concept, it would be enough to create 12 tables with one table per month, and thus partition the sales data monthly. For example:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>January: SALES_01<\/li>\n\n\n\n<li>February: SALES_02<\/li>\n\n\n\n<li>March: SALES_03<\/li>\n\n\n\n<li>April: SALES_04<\/li>\n\n\n\n<li>May: SALES_05<\/li>\n\n\n\n<li>June : SALES_06<\/li>\n\n\n\n<li>July : SALES_07<\/li>\n\n\n\n<li>August : SALES_08<\/li>\n\n\n\n<li>September : SALES_09<\/li>\n\n\n\n<li>October : SALES_10<\/li>\n\n\n\n<li>November : SALES_11<\/li>\n\n\n\n<li>December: SALES_12<\/li>\n<\/ol>\n\n\n\n<p>Paradoxically, note <strong>that it is possible to insert data into a SQL Server view<\/strong>. This means that the data will be inserted directly into the view&#8217;s source table. Obviously, only the columns present in the view are accessible from the <a href=\"https:\/\/expert-only.com\/en\/t-sql\/insert-or-update-with-sql-server\/\">Insert Into command<\/a>.<\/p>\n\n\n\n<p>To conclude, this simple tutorial shows how to create a partitioned view in SQL Server. The method allows to make performance improvements because the system accesses each table faster than one single table. To go further and improve performance of queries check out the partition section and <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-table-size-disk-space\/\">how to check table size and disk space<\/a>.<\/p>\n\n\n\n<p>In this way, a query filtered on a particular month will only retrieve data on one table. In addition, here is <a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\">how to create a table with SQL Server<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"nL5gFHpcFR\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\">CREATE TABLE with SQL Server<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;CREATE TABLE with SQL Server&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/embed\/#?secret=TyJCFKx4ds#?secret=nL5gFHpcFR\" data-secret=\"nL5gFHpcFR\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to Create SQL Server partitioned views to group data from multiple tables? Find examples of scripts to create views that points to four or more different tables. In this example, each Sales table would contain the sales of <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\" title=\"Create SQL Server partitioned views to group tables having partitions\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10914,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-9195","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create SQL Server partitioned views - SQL Partitions - T-SQL<\/title>\n<meta name=\"description\" content=\"Create SQL Server partitioned views in order to group tables and increase query performance, and organize data from multiple source tables.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create SQL Server partitioned views to group tables having partitions\" \/>\n<meta property=\"og:description\" content=\"Create SQL Server partitioned views in order to group tables and increase query performance, and organize data from multiple source tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-01T05:17:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-02T11:49:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Create SQL Server partitioned views to group tables having partitions\",\"datePublished\":\"2022-08-01T05:17:00+00:00\",\"dateModified\":\"2023-03-02T11:49:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\"},\"wordCount\":566,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\",\"name\":\"Create SQL Server partitioned views - SQL Partitions - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg\",\"datePublished\":\"2022-08-01T05:17:00+00:00\",\"dateModified\":\"2023-03-02T11:49:14+00:00\",\"description\":\"Create SQL Server partitioned views in order to group tables and increase query performance, and organize data from multiple source tables.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create SQL Server partitioned views to group tables having partitions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Create SQL Server partitioned views - SQL Partitions - T-SQL","description":"Create SQL Server partitioned views in order to group tables and increase query performance, and organize data from multiple source tables.","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:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/","og_locale":"en_US","og_type":"article","og_title":"Create SQL Server partitioned views to group tables having partitions","og_description":"Create SQL Server partitioned views in order to group tables and increase query performance, and organize data from multiple source tables.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-08-01T05:17:00+00:00","article_modified_time":"2023-03-02T11:49:14+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Create SQL Server partitioned views to group tables having partitions","datePublished":"2022-08-01T05:17:00+00:00","dateModified":"2023-03-02T11:49:14+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/"},"wordCount":566,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/","url":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/","name":"Create SQL Server partitioned views - SQL Partitions - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg","datePublished":"2022-08-01T05:17:00+00:00","dateModified":"2023-03-02T11:49:14+00:00","description":"Create SQL Server partitioned views in order to group tables and increase query performance, and organize data from multiple source tables.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/typewriter-83FA909F31B_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-sql-server-partitioned-views\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Create SQL Server partitioned views to group tables having partitions"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/9195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=9195"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/9195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10914"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=9195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=9195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=9195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}