Breaking News: Grepper is joining You.com. Read the official announcement!

Rebuild Index SQL Server

Add Answer

Lively Lobster answered on May 30, 2021 Popularity 9/10 Helpfulness 3/10

answer Rebuild Index SQL Server

related rebuild index table sql script

related rebuild index sql server

Rebuild Index SQL Server

Comment

DECLARE @Database NVARCHAR(255)   
    DECLARE @Table NVARCHAR(255)  
    DECLARE @cmd NVARCHAR(1000)  

    DECLARE DatabaseCursor CURSOR READ_ONLY FOR  
    SELECT name FROM master.sys.databases   
    WHERE name IN ('YOUR DATABASE NAME')  -- databases
    AND state = 0 -- database is online
    AND is_in_standby = 0 -- database is not read only for log shipping
    ORDER BY 1  

    OPEN DatabaseCursor  

    FETCH NEXT FROM DatabaseCursor INTO @Database  
    WHILE @@FETCH_STATUS = 0  
    BEGIN  

       SET @cmd = 'DECLARE TableCursor CURSOR READ_ONLY FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' +  
       table_name + '']'' as tableName FROM [' + @Database + '].INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE'''   

       -- create table cursor  
       EXEC (@cmd)  
       OPEN TableCursor   

       FETCH NEXT FROM TableCursor INTO @Table   
       WHILE @@FETCH_STATUS = 0   
       BEGIN
          BEGIN TRY   
             SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD' 
             PRINT @cmd -- uncomment if you want to see commands
             EXEC (@cmd) 
          END TRY
          BEGIN CATCH
             PRINT '---'
             PRINT @cmd
             PRINT ERROR_MESSAGE() 
             PRINT '---'
          END CATCH

          FETCH NEXT FROM TableCursor INTO @Table   
       END   

       CLOSE TableCursor   
       DEALLOCATE TableCursor  

       FETCH NEXT FROM DatabaseCursor INTO @Database  
    END  
    CLOSE DatabaseCursor   
    DEALLOCATE DatabaseCursor

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: rebuild sql sql-server

Link to this answer
Share Copy Link

Contributed on Feb 02 2022

Lively Lobster

0 Answers Avg Quality 2/10

Closely Related Answers

rebuild index table sql script

Comment

ALTER INDEX ALL ON [table_name] REBUILD

Popularity 9/10 Helpfulness 9/10 Language sql

Source: codingsight.com

Tags: rebuild

Link to this answer
Share Copy Link

Contributed on Sep 14 2022

Jocksan Cruz

0 Answers Avg Quality 2/10

rebuild index sql server

Comment

In Object Explorer, Expand the database that contains the table on which you want to reorganize an index.
Expand the Tables folder.
Expand the table on which you want to reorganize an index.
Expand the Indexes folder.
Right-click the index you want to reorganize and select Rebuild.

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: rebuild

Link to this answer
Share Copy Link

Contributed on May 30 2021

Frightened Ferret

0 Answers Avg Quality 2/10

rebuild index sql server

Comment

ALTER INDEX ALL ON YourTableName
REBUILD;

Popularity 7/10 Helpfulness 3/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

Rebuild Index SQL Server

Contents

More Related Answers

Rebuild Index SQL Server

Closely Related Answers

rebuild index table sql script

rebuild index sql server

rebuild index sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.