{"id":1508,"date":"2018-08-10T10:44:39","date_gmt":"2018-08-10T10:44:39","guid":{"rendered":"http:\/\/dbtut.com\/?p=1508"},"modified":"2018-11-09T21:52:35","modified_gmt":"2018-11-09T21:52:35","slug":"how-to-create-partition-on-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/","title":{"rendered":"How To Create Partition On SQL Server"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Partition is the process of dividing tables and indexes into parts.<\/p>\n<p>For example, I have a table with a size of 1 TB.<\/p>\n<p>And this table has a column with datetime type.<\/p>\n<p>You can divide the table by day, month, or year according to this datetime column.<\/p>\n<p>In an example I saw earlier, an application developer created a different table for each month so that the table would not grow too large.<\/p>\n<p>In this way, hundreds of tables are created for the same job in the database.<\/p>\n<p>SQL Server can provide this feature with partition method.<\/p>\n<p>You are using a single table instead of hundreds of tables.<\/p>\n<p>SQL Server divides the values \u200b\u200bin this table into partitions.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>What are the benefits of partitioning?<\/strong><\/p>\n<ul>\n<li>Let&#8217;s consider that we make the table partition month by month. When we try to reach a third month, we will be able to access the partition faster because we will only access the third month&#8217;s partition.<\/li>\n<li>If we want to perform maintenance operations such as index rebuild, index reorganize on the table, we can do partition based instead of whole table. This way we will be able to perform this operation more quickly.<\/li>\n<li>If two tables are partitioned according to the same column and join these two tables through this column, you will get a significant performance increase. Because partitions can be joined on a partition basis.<\/li>\n<li>You can increase performance by activating Lock Escalation on a partition basis instead of all tables. With the help of the following query, we can make lock escalation partition-based on partitioned tables. If the table is not partitioned, the lock escalation will be based on the table.<\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \">ALTER TABLE T1 SET (LOCK_ESCALATION = AUTO)<\/pre>\n<p>&nbsp;<\/p>\n<p>Lock Escalation is the process of converting a large number of small level locks into a smaller number of upper level locks.<\/p>\n<p>For example, many row locks are converted into page locks.<\/p>\n<p>SQL Server does this automatically.<\/p>\n<p>You may want to read the article titled &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/24\/sql-server-lock-types\/\" target=\"_blank\" rel=\"noopener\">SQL Server Lock Types<\/a>&#8220;.<\/p>\n<p>When you create a partition, you can put each partition in a different filegroup.<\/p>\n<p>By putting these files on different disks, you can also increase I\/O performance.<\/p>\n<p>For more information about the Filegroup, you may want to read the article &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/01\/how-to-create-a-database-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">How To Create a Database On SQL Server<\/a>&#8220;.<\/p>\n<p>To put partitions into different file groups, we create two file groups with the help of the following script. I create one file in each filegroup.<\/p>\n<pre class=\"lang:default decode:true\">USE Test\r\n\r\nALTER DATABASE Test\r\nADD FILEGROUP FileGroup1\r\n\r\nALTER DATABASE Test\r\nADD FILEGROUP FileGroup2\r\n\r\nALTER DATABASE Test\r\nADD FILEGROUP FileGroup3\r\n\r\n\r\nALTER DATABASE Test\r\nADD FILE ( NAME = DataFile1,\r\nFILENAME = 'C:\\MSSQL\\TestDataFile1.ndf')\r\nTO FILEGROUP FileGroup1\r\n\r\nALTER DATABASE Test\r\nADD FILE ( NAME = DataFile2,\r\nFILENAME = 'C:\\MSSQL\\TestDataFile2.ndf')\r\nTO FILEGROUP FileGroup2\r\n\r\nALTER DATABASE Test\r\nADD FILE ( NAME = DataFile3,\r\nFILENAME = 'C:\\MSSQL\\TestDataFile3.ndf')\r\nTO FILEGROUP FileGroup3<\/pre>\n<p>&nbsp;<\/p>\n<p>Use the following script to create the partition function and partition schema.<\/p>\n<p>In the partition function, we specify that the dates for January 1 2007 and earlier will be on a partition, that the data from January 1 2007 to January 1 2008 will be on another partition, and the rest will be on another partition.<\/p>\n<p>In the Partition Schema, we also specify filegroups.<\/p>\n<pre class=\"lang:default decode:true\">CREATE PARTITION FUNCTION RecordTimePartition (DATETIME)\r\nAS RANGE RIGHT FOR VALUES ('20070101',20080101')<\/pre>\n<pre class=\"lang:default decode:true\">CREATE PARTITION SCHEME RecordTimeScheme\r\nAS PARTITION RecordTimePartition TO (FileGroup1, FileGroup2,FileGroup3)<\/pre>\n<p>&nbsp;<\/p>\n<p>Use the following script to create a table that uses this partition.<\/p>\n<p>The same partition structure can be used by more than one table.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE [dbo].[PartitionExample](\r\n[ID] [int] IDENTITY(1,1) NOT NULL,\r\n[Name] [varchar](250) NULL,\r\n[RecordTime] [datetime] NULL\r\n) ON RecordTimeScheme (RecordTime)\r\n\r\nALTER TABLE dbo.PartitionExample SET (LOCK_ESCALATION = TABLE)<\/pre>\n<p>&nbsp;<\/p>\n<p>Perform four insert operations to the table with the following script.<\/p>\n<pre class=\"lang:default decode:true\">INSERT INTO dbo.PartitionExample(Name,RecordTime)\r\nVALUES ('Nurullah \u00c7AKIR','20080201')\r\n\r\nINSERT INTO dbo.PartitionExample(Name,RecordTime)\r\nVALUES ('Faruk ERDEM', '20070101')\r\n\r\nINSERT INTO dbo.PartitionExample(Name,RecordTime)\r\nVALUES ('Hakan GURBASLAR','20090101')\r\n\r\nINSERT INTO dbo.PartitionExample(Name,RecordTime)\r\nVALUES (DILARA AYDIN','20040401')<\/pre>\n<p>&nbsp;<\/p>\n<p>We can use the following script to query which record is on which partition.<\/p>\n<pre class=\"lang:default decode:true\">SELECT Name,RecordTime,\r\n$PARTITION.RecordTimePartition(RecordTime) PARTITION\r\nFROM dbo.PartitionExample\r\nORDER BY RecordTime<\/pre>\n<p>&nbsp;<\/p>\n<h3>How can we partition an existing table?<\/h3>\n<p><strong>First Method:<\/strong><\/p>\n<p>By creating a new table in the partition structure, we can export the data in the current table into this new table.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Second Method:<\/strong><\/p>\n<p>First, we delete the table we created in our example and recreate it without the partition structure.<\/p>\n<pre class=\"lang:default decode:true\">USE [Test]\r\nGO\r\nCREATE TABLE [dbo].[PartitionExample](\r\n[ID] [int] IDENTITY(1,1) NOT NULL,\r\n[Name] [varchar](250) NULL,\r\n[RecordTime] [datetime] NULL\r\n) ON [PRIMARY]<\/pre>\n<p>&nbsp;<\/p>\n<p>Later I will add a few records to this table as below.<\/p>\n<pre class=\"lang:default decode:true\">INSERT INTO dbo.PartitionExample(Name,RecordTime)\u00a0\r\nVALUES ('Nurullah \u00c7AKIR','20080201')\u00a0\r\nINSERT INTO dbo.PartitionExample(Name,RecordTime)\u00a0\r\nVALUES ('Faruk ERDEM', '20070101')\u00a0\r\nINSERT INTO dbo.PartitionExample(Name,RecordTime)\u00a0\r\nVALUES ('Hakan GURBASLAR,'20090101')\u00a0\r\nINSERT INTO dbo.PartitionExample(Name,RecordTime)\u00a0\r\nVALUES (DILARA AYDIN','20040401')<\/pre>\n<p>&nbsp;<\/p>\n<p>With the following script, we can query how many records are in which partition.<\/p>\n<pre class=\"lang:default decode:true\">SELECT partition_id, object_id, partition_number, rows \r\nFROM sys.partitions\r\nWHERE object_id = OBJECT_ID('PartitionExample')<\/pre>\n<p>&nbsp;<\/p>\n<p>Then we can make the table partitioned by creating a clustered index on the table with the following script.<\/p>\n<pre class=\"lang:default decode:true\">USE [Test]\r\nGO\r\nCREATE CLUSTERED INDEX [CIX] ON [dbo].[PartitionExample]\r\n(\r\n[ID] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, \r\nONLINE = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)\r\nON RecordTimeScheme (RecordTime)<\/pre>\n<p>&nbsp;<\/p>\n<p>If there is a clustered index, we should get create script as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png\" width=\"570\" height=\"53\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We need to set the drop existing in the script to &#8220;ON&#8221;, and at the end we have to write the value of &#8220;ON RecordTimeScheme(RecordTime)&#8221;.<\/p>\n<p>&#8220;RecordTimeScheme&#8221; is the partition scheme.<\/p>\n<p>&#8220;RecordTime&#8221; is the name of the partition column.<\/p>\n<p>The final structure of the script should be in the following structure.<\/p>\n<pre class=\"lang:default decode:true\">USE [Test]\r\nGO\r\nCREATE CLUSTERED INDEX [CIX] ON [dbo].[PartitionExample]\r\n(\r\n[ID] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = ON, \r\nONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)\r\nON RecordTimeSchema(RecordTime)<\/pre>\n<p>&nbsp;<\/p>\n<p>You can find the sliding window scenario and switch partition issues related to partition in the article titled &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/19\/sliding-window-switch-partition-split-range-merge-range\/\" target=\"_blank\" rel=\"noopener\">Sliding Window-Switch Partition-Split Range-Merge Range<\/a>&#8220;.<\/p>\n<p>To avoid troubles in the switch partition process, all the indexes in the partitioned table must be aligned according to the partition schema.<\/p>\n<p>You may want to take a look at &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/17\/can-not-switch-the-partition-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">Can Not Switch The Partition\u00a0On SQL Server<\/a>&#8221; to see what the alignment process is and how it is done.<\/p>\n<p>You can also use the following articles to see partitioned tables and partition details.<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/11\/how-to-find-partitioned-tables-in-the-database-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">How To Find Partitioned Tables In The Database On SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/15\/how-to-see-partition-details-in-partitioned-table-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">How To See Partition Details In Partitioned Table On SQL Server<\/a>&#8221;<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1508\" class=\"pvc_stats all  \" data-element-id=\"1508\" 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>&nbsp; Partition is the process of dividing tables and indexes into parts. For example, I have a table with a size of 1 TB. And this table has a column with datetime type. You can divide the table by day, month, or year according to this datetime column. In an example I saw earlier, an &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1508\" class=\"pvc_stats all  \" data-element-id=\"1508\" 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":0,"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":[1384,1385,1386],"class_list":["post-1508","post","type-post","status-publish","format-standard","","category-mssql","tag-create-partition","tag-partition-schema","tag-partitionfunction"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":863,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create Partition On SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create Partition On 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\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Partition On SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create Partition On SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-10T10:44:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-09T21:52:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Create Partition On SQL Server\",\"datePublished\":\"2018-08-10T10:44:39+00:00\",\"dateModified\":\"2018-11-09T21:52:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\"},\"wordCount\":802,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png\",\"keywords\":[\"Create Partition\",\"Partition Schema\",\"PartitionFunction\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\",\"name\":\"How To Create Partition On SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png\",\"datePublished\":\"2018-08-10T10:44:39+00:00\",\"dateModified\":\"2018-11-09T21:52:35+00:00\",\"description\":\"How To Create Partition On SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Partition On 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":"How To Create Partition On SQL Server - Database Tutorials","description":"How To Create Partition On 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\/2018\/08\/10\/how-to-create-partition-on-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Create Partition On SQL Server - Database Tutorials","og_description":"How To Create Partition On SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-10T10:44:39+00:00","article_modified_time":"2018-11-09T21:52:35+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Create Partition On SQL Server","datePublished":"2018-08-10T10:44:39+00:00","dateModified":"2018-11-09T21:52:35+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/"},"wordCount":802,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png","keywords":["Create Partition","Partition Schema","PartitionFunction"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/","name":"How To Create Partition On SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png","datePublished":"2018-08-10T10:44:39+00:00","dateModified":"2018-11-09T21:52:35+00:00","description":"How To Create Partition On SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/322.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create Partition On 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\/1508","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=1508"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1508\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}