{"id":252,"date":"2018-07-21T10:55:15","date_gmt":"2018-07-21T00:55:15","guid":{"rendered":"http:\/\/kswp01.azurewebsites.net\/?p=252"},"modified":"2018-07-21T10:55:15","modified_gmt":"2018-07-21T00:55:15","slug":"rebuild-all-indexis","status":"publish","type":"post","link":"https:\/\/kswp01.azurewebsites.net\/?p=252","title":{"rendered":"Rebuild All Indexis"},"content":{"rendered":"<h3>How to rebuild all indexes in a database<\/h3>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<pre>DECLARE @TableName VARCHAR(255)\r\nDECLARE @sql NVARCHAR(500)\r\nDECLARE @fillfactor INT\r\nSET @fillfactor = 80 \r\nDECLARE TableCursor CURSOR FOR\r\nSELECT '[' + OBJECT_SCHEMA_NAME([object_id])+'].['+name+']' AS TableName\r\nFROM sys.tables\r\nOPEN TableCursor\r\nFETCH NEXT FROM TableCursor INTO @TableName\r\nWHILE @@FETCH_STATUS = 0\r\nBEGIN\r\nSET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'\r\nEXEC (@sql)\r\nFETCH NEXT FROM TableCursor INTO @TableName\r\nEND\r\nCLOSE TableCursor\r\nDEALLOCATE TableCursor\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<h3>References<\/h3>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/32505775\/rebuild-all-indexes-in-a-database\" target=\"_blank\" rel=\"noopener\">https:\/\/stackoverflow.com\/questions\/32505775\/rebuild-all-indexes-in-a-database<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to rebuild all indexes in a database<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts\/252"}],"collection":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":1,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions"}],"predecessor-version":[{"id":253,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions\/253"}],"wp:attachment":[{"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kswp01.azurewebsites.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}