Home Forums SQL Server 2008 SQL Server 2008 Administration Rebuild Online Index in Partationed Table RE: Rebuild Online Index in Partationed Table
pawana.paul
SSCommitted
Points: 1686
More actions
August 11, 2014 at 5:21 pm
#1737075
Thank you Jeff,
Can we do offline rebuild of partation in SQL 2008 Version with the below syntax?
ALTER INDEX IX_TransactionHistory_TransactionDate
ON Production.TransactionHistory
REBUILD Partition = 5