Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

usp_PartitionDatabase Expand / Collapse
Author
Message
Posted Friday, April 17, 2009 1:31 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 2012 9:04 AM
Points: 84, Visits: 144
Comments posted to this topic are about the item usp_PartitionDatabase
Post #699734
Posted Saturday, May 29, 2010 10:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 4:55 AM
Points: 55, Visits: 235
Hi,

Great procedure !

Do you have some procedure that is also taken care of "auto" creating new partitions (...and deletes the ones that are close to 1000 limit) for SQL 2008 ?

Some process that will be run on a daily scheduled time that will handle this issue also, this will be really awesome.

Thanks a lot.
Victor S.
Post #930068
Posted Thursday, May 19, 2016 7:04 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:55 AM
Points: 8,101, Visits: 812
Thanks for the script.
Post #1787698
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse