Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rebuild Partitioned Indexes Expand / Collapse
Author
Message
Posted Tuesday, November 24, 2009 9:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 21, 2010 3:07 PM
Points: 1, Visits: 13
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
Post #823996
Posted Thursday, April 12, 2012 3:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 10, 2012 1:15 PM
Points: 26, Visits: 233
Annoying to see no reply for this..
Post #1282215
Posted Friday, April 13, 2012 7:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 07, 2012 8:27 AM
Points: 68, Visits: 284
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.
Post #1283152
Posted Wednesday, July 18, 2012 3:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 10, 2012 1:15 PM
Points: 26, Visits: 233
Its ok to run the query you have.
Post #1331854
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse