• Reorgs should look something like this:

    USE [DatabaseName]

    GO

    ALTER INDEX [IndexName] ON [dbo].[TableName] REORGANIZE WITH ( LOB_COMPACTION = ON )

    GO

    Rebuilds would look something like this:

    USE [DatabaseName]

    GO

    ALTER INDEX [IndexName] ON [dbo].[TableName] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )

    GO

    The WITH section of each will vary. Check out the ALTER INDEX pages in BOL for the various options.