{"id":21693,"date":"2021-11-03T04:46:04","date_gmt":"2021-11-03T04:46:04","guid":{"rendered":"https:\/\/dbtut.com\/?p=21693"},"modified":"2021-11-03T04:46:04","modified_gmt":"2021-11-03T04:46:04","slug":"moving-all-nonclustered-indexes-to-another-filegroup","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/","title":{"rendered":"Moving all Nonclustered Indexes to Another Filegroup"},"content":{"rendered":"<p>On one of our customer we had to move all nonclustered indexes to another filegroup and we have found a solution for it and I wanted to share with you.<\/p>\n<p>Actually if you have not too much indexes on your database you can go your all indexes one by one and get create script with DROP_EXISTING=ON option and you can create your indexes on another filegroup. if you dont know about DROP_EXISTING option, when you create your indexes with this option, SQL Server will create new index and delete the old one. So if you change ON PRIMARY to ON ANOTHERFILEGROUP on your index creation script with this option you will move your indexes.<\/p>\n<p>However in many systems there are too much nonclustered indexes and sometimes that may be hard to seperate pk and nonclustered indexes. Below script have helped me alot.<\/p>\n<h3>Move All Nonclustered Index to Another Filegroup<\/h3>\n<p>This script will give the current create script of all nonclustered indexes in your database. Dont forget to change ON PRIMARY to ON AnotherFilegroup and if you want you can add ONLINE=ON,MAXDOP=10 or something else,FILLFACTOR=90. Generally I am using them.<\/p>\n<pre class=\"lang:default decode:true\">DECLARE @SchemaName VARCHAR(100)\r\nDECLARE @TableName VARCHAR(256)\r\nDECLARE @IndexName VARCHAR(256)\r\nDECLARE @ColumnName VARCHAR(100)\r\nDECLARE @is_unique VARCHAR(100)\r\nDECLARE @IndexTypeDesc VARCHAR(100)\r\nDECLARE @FileGroupName VARCHAR(100)\r\nDECLARE @is_disabled VARCHAR(100)\r\nDECLARE @IndexOptions VARCHAR(MAX)\r\nDECLARE @IsDescendingKey INT\r\nDECLARE @IsIncludedColumn INT\r\nDECLARE @TSQLScripCreationIndex VARCHAR(MAX)\r\nDECLARE @TSQLScripDisableIndex VARCHAR(MAX)\r\n\r\nDECLARE CursorIndex CURSOR FOR\r\nSELECT\r\n\t\t schema_name   = SCHEMA_NAME(t.schema_id)\r\n\t\t,t.name\r\n\t\t,ix.name\r\n\t\t,CASE\r\n\t\t\t WHEN ix.is_unique = 1 THEN 'UNIQUE '\r\n\t\t\t ELSE ''\r\n\t\t END\r\n\t\t,ix.type_desc\r\n\t\t,IndexOptions  = CASE\r\n\t\t\t\t\t\t\t WHEN ix.is_padded = 1 THEN 'PAD_INDEX = ON, '\r\n\t\t\t\t\t\t\t ELSE 'PAD_INDEX = OFF, '\r\n\t\t\t\t\t\t END + CASE\r\n\t\t\t\t\t\t\t\t   WHEN ix.allow_page_locks = 1 THEN 'ALLOW_PAGE_LOCKS = ON, '\r\n\t\t\t\t\t\t\t\t   ELSE 'ALLOW_PAGE_LOCKS = OFF, '\r\n\t\t\t\t\t\t\t   END + CASE\r\n\t\t\t\t\t\t\t\t\t\t WHEN ix.allow_row_locks = 1 THEN 'ALLOW_ROW_LOCKS = ON, '\r\n\t\t\t\t\t\t\t\t\t\t ELSE 'ALLOW_ROW_LOCKS = OFF, '\r\n\t\t\t\t\t\t\t\t\t END\r\n\t\t\t\t\t\t + CASE\r\n\t\t\t\t\t\t\t   WHEN INDEXPROPERTY(t.object_id, ix.name, 'IsStatistics') = 1 THEN\r\n\t\t\t\t\t\t\t\t   'STATISTICS_NORECOMPUTE = ON, '\r\n\t\t\t\t\t\t\t   ELSE 'STATISTICS_NORECOMPUTE = OFF, '\r\n\t\t\t\t\t\t   END + CASE\r\n\t\t\t\t\t\t\t\t\t WHEN ix.ignore_dup_key = 1 THEN 'IGNORE_DUP_KEY = ON, '\r\n\t\t\t\t\t\t\t\t\t ELSE 'IGNORE_DUP_KEY = OFF, '\r\n\t\t\t\t\t\t\t\t END + 'SORT_IN_TEMPDB = OFF, FILLFACTOR = 90' \r\n\t\t,ix.is_disabled\r\n\t\t,FileGroupName = FILEGROUP_NAME(ix.data_space_id)\r\nFROM\t sys.tables\t AS t\r\n\t\t INNER JOIN\r\n\t\t sys.indexes AS ix ON t.object_id = ix.object_id\r\nWHERE\t ix.type &gt; 0\r\n\t AND ix.is_primary_key = 0\r\n\t AND ix.is_unique_constraint = 0 --and schema_name(tb.schema_id)= @SchemaName and tb.name=@TableName\r\n\t AND t.is_ms_shipped = 0\r\n\t AND t.name &lt;&gt; 'sysdiagrams'\r\n\t AND ix.data_space_id &lt;= 32767\r\n\r\nORDER BY SCHEMA_NAME(t.schema_id)\r\n\t\t,t.name\r\n\t\t,ix.name\r\n\r\nOPEN CursorIndex\r\nFETCH NEXT FROM CursorIndex\r\nINTO\r\n\t@SchemaName\r\n   ,@TableName\r\n   ,@IndexName\r\n   ,@is_unique\r\n   ,@IndexTypeDesc\r\n   ,@IndexOptions\r\n   ,@is_disabled\r\n   ,@FileGroupName\r\n\r\nWHILE (@@fetch_status = 0)\r\n\tBEGIN\r\n\t\tDECLARE @IndexColumns VARCHAR(MAX)\r\n\t\tDECLARE @IncludedColumns VARCHAR(MAX)\r\n\r\n\t\tSET @IndexColumns = ''\r\n\t\tSET @IncludedColumns = ''\r\n\r\n\t\tDECLARE CursorIndexColumn CURSOR FOR\r\n\t\tSELECT\r\n\t\t\t\t col.name\r\n\t\t\t\t,ixc.is_descending_key\r\n\t\t\t\t,ixc.is_included_column\r\n\t\tFROM\t sys.tables\t\t   AS tb\r\n\t\t\t\t INNER JOIN\r\n\t\t\t\t sys.indexes\t   AS ix ON tb.object_id = ix.object_id\r\n\t\t\t\t INNER JOIN\r\n\t\t\t\t sys.index_columns AS ixc ON ix.object_id = ixc.object_id AND ix.index_id = ixc.index_id\r\n\t\t\t\t INNER JOIN\r\n\t\t\t\t sys.columns\t   AS col ON ixc.object_id = col.object_id AND ixc.column_id = col.column_id\r\n\t\tWHERE\t ix.type &gt; 0\r\n\t\t\t AND (\r\n\t\t\t\t\t ix.is_primary_key = 0 OR ix.is_unique_constraint = 0\r\n\t\t\t\t )\r\n\t\t\t AND SCHEMA_NAME(tb.schema_id) = @SchemaName\r\n\t\t\t AND tb.name = @TableName\r\n\t\t\t AND ix.name = @IndexName\r\n\r\n\t\tORDER BY ixc.index_column_id\r\n\r\n\t\tOPEN CursorIndexColumn\r\n\t\tFETCH NEXT FROM CursorIndexColumn\r\n\t\tINTO\r\n\t\t\t@ColumnName\r\n\t\t   ,@IsDescendingKey\r\n\t\t   ,@IsIncludedColumn\r\n\r\n\t\tWHILE (@@fetch_status = 0)\r\n\t\t\tBEGIN\r\n\t\t\t\tIF @IsIncludedColumn = 0\r\n\t\t\t\t\tSET @IndexColumns = @IndexColumns + @ColumnName + CASE\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  WHEN @IsDescendingKey = 1 THEN ' DESC, '\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  ELSE ' ASC, '\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t  END\r\n\t\t\t\tELSE\r\n\t\t\t\t\tSET @IncludedColumns = @IncludedColumns + @ColumnName + ', '\r\n\r\n\t\t\t\tFETCH NEXT FROM CursorIndexColumn\r\n\t\t\t\tINTO\r\n\t\t\t\t\t@ColumnName\r\n\t\t\t\t   ,@IsDescendingKey\r\n\t\t\t\t   ,@IsIncludedColumn\r\n\t\t\tEND\r\n\r\n\t\tCLOSE CursorIndexColumn\r\n\t\tDEALLOCATE CursorIndexColumn\r\n\r\n\t\tSET @IndexColumns = SUBSTRING(@IndexColumns, 1, LEN(@IndexColumns) - 1)\r\n\t\tSET @IncludedColumns = CASE\r\n\t\t\t\t\t\t\t\t   WHEN LEN(@IncludedColumns) &gt; 0 THEN\r\n\t\t\t\t\t\t\t\t\t   SUBSTRING(@IncludedColumns, 1, LEN(@IncludedColumns) - 1)\r\n\t\t\t\t\t\t\t\t   ELSE ''\r\n\t\t\t\t\t\t\t   END\r\n\t\t--  print @IndexColumns\r\n\t\t--  print @IncludedColumns\r\n\r\n\t\tSET @TSQLScripCreationIndex = ''\r\n\t\tSET @TSQLScripDisableIndex = ''\r\n\t\tSET @TSQLScripCreationIndex = 'CREATE ' + @is_unique + @IndexTypeDesc + ' INDEX ' + QUOTENAME(@IndexName)\r\n\t\t\t\t\t\t\t\t\t  + ' ON ' + QUOTENAME(@SchemaName) + '.' + QUOTENAME(@TableName) + '('\r\n\t\t\t\t\t\t\t\t\t  + @IndexColumns + ') '\r\n\t\t\t\t\t\t\t\t\t  + CASE\r\n\t\t\t\t\t\t\t\t\t\t\tWHEN LEN(@IncludedColumns) &gt; 0 THEN\r\n\t\t\t\t\t\t\t\t\t\t\t\tCHAR(13) + 'INCLUDE (' + @IncludedColumns + ')'\r\n\t\t\t\t\t\t\t\t\t\t\tELSE ''\r\n\t\t\t\t\t\t\t\t\t\tEND + CHAR(13) + 'WITH (' + @IndexOptions + ', ONLINE=ON, MAXDOP=10, DROP_EXISTING=ON) ON TABLESGROUP'\r\n\t\t\t\t\t\t\t\t\t  + ';'\r\n\r\n\t\tIF @is_disabled = 1\r\n\t\t\tSET @TSQLScripDisableIndex = CHAR(13) + 'ALTER INDEX ' + QUOTENAME(@IndexName) + ' ON '\r\n\t\t\t\t\t\t\t\t\t\t + QUOTENAME(@SchemaName) + '.' + QUOTENAME(@TableName) + ' DISABLE;'\r\n\t\t\t\t\t\t\t\t\t\t + CHAR(13)\r\n\r\n\t\tPRINT @TSQLScripCreationIndex\r\n\t\tPRINT @TSQLScripDisableIndex\r\n\r\n\t\tFETCH NEXT FROM CursorIndex\r\n\t\tINTO\r\n\t\t\t@SchemaName\r\n\t\t   ,@TableName\r\n\t\t   ,@IndexName\r\n\t\t   ,@is_unique\r\n\t\t   ,@IndexTypeDesc\r\n\t\t   ,@IndexOptions\r\n\t\t   ,@is_disabled\r\n\t\t   ,@FileGroupName\r\n\r\n\tEND\r\nCLOSE CursorIndex\r\nDEALLOCATE CursorIndex<\/pre>\n<p>Here is the link where I have found this create script.<\/p>\n<p>https:\/\/www.mssqltips.com\/sqlservertip\/3441\/script-out-all-sql-server-indexes-in-a-database-using-tsql\/<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21693\" class=\"pvc_stats all  \" data-element-id=\"21693\" 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>On one of our customer we had to move all nonclustered indexes to another filegroup and we have found a solution for it and I wanted to share with you. Actually if you have not too much indexes on your database you can go your all indexes one by one and get create script with &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_21693\" class=\"pvc_stats all  \" data-element-id=\"21693\" 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":21694,"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":[],"class_list":["post-21693","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":481,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Moving all Nonclustered Indexes to Another Filegroup - Database Tutorials<\/title>\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\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Moving all Nonclustered Indexes to Another Filegroup - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"On one of our customer we had to move all nonclustered indexes to another filegroup and we have found a solution for it and I wanted to share with you. Actually if you have not too much indexes on your database you can go your all indexes one by one and get create script with &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-03T04:46:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"709\" \/>\n\t<meta property=\"og:image:height\" content=\"399\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Moving all Nonclustered Indexes to Another Filegroup\",\"datePublished\":\"2021-11-03T04:46:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\"},\"wordCount\":219,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\",\"name\":\"Moving all Nonclustered Indexes to Another Filegroup - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg\",\"datePublished\":\"2021-11-03T04:46:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg\",\"width\":709,\"height\":399},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Moving all Nonclustered Indexes to Another Filegroup\"}]},{\"@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":"Moving all Nonclustered Indexes to Another Filegroup - Database Tutorials","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\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/","og_locale":"en_US","og_type":"article","og_title":"Moving all Nonclustered Indexes to Another Filegroup - Database Tutorials","og_description":"On one of our customer we had to move all nonclustered indexes to another filegroup and we have found a solution for it and I wanted to share with you. Actually if you have not too much indexes on your database you can go your all indexes one by one and get create script with &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/","og_site_name":"Database Tutorials","article_published_time":"2021-11-03T04:46:04+00:00","og_image":[{"width":709,"height":399,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg","type":"image\/jpeg"}],"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\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Moving all Nonclustered Indexes to Another Filegroup","datePublished":"2021-11-03T04:46:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/"},"wordCount":219,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/","url":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/","name":"Moving all Nonclustered Indexes to Another Filegroup - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg","datePublished":"2021-11-03T04:46:04+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/11\/movenonclustredindexes.jpg","width":709,"height":399},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2021\/11\/03\/moving-all-nonclustered-indexes-to-another-filegroup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Moving all Nonclustered Indexes to Another Filegroup"}]},{"@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\/21693","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=21693"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/21693\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/21694"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=21693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=21693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=21693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}