November 24, 2009 at 9:54 am
When you have to rebuild an index that has partitions do you have to specify the partitions within the indexes or will simply identifying the index like I have written below do the trick?
USE [TestDB]
GO
ALTER INDEX [in_tbl_doc2_address_address_id] ON [TestDB].[tbl_doc2_address] REBUILD WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = ON, ONLINE = OFF )
Thanks,
Shawn
April 12, 2012 at 3:46 am
Annoying to see no reply for this..
April 13, 2012 at 7:51 am
http://msdn.microsoft.com/en-US/library/ms189858(v=sql.105).aspx
See link. It's an either by partition or all.
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
July 18, 2012 at 3:33 pm
Its ok to run the query you have.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply