Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Hugh Scott Automate Sliding Window Partition Management: Part I RE: Automate Sliding Window Partition Management: Part I

  • December 15, 2010 at 1:57 pm

    #1263139

    Hugh Scott (12/14/2010)

    amenjonathan (12/14/2010)

    Thanks merlin for your reply and Hugh for this article. Looking forward to the next two installments.

    Anybody have any idea what happens when you do not add the partitioned column to an index? Does it still create an aligned index (by secretly adding it anyway)?

    Nope. The index gets created on the default file group. Not that I would know from experience!:-D

    Regards,

    Hugh

    From vague memory and recollections of BoL, the partitioned column is added (as an included column) to a non-clustered index only if there is no clustered index... although please don't quote me on this!

    --Chris Hamam

    Life's a beach, then you DIE (Do It Eternally)