Home Forums SQL Server 2005 SQL Server Newbies Changing Filegroup names and Filegroup files - midstream. . . RE: Changing Filegroup names and Filegroup files - midstream. . .

  • April 30, 2012 at 4:27 pm

    #1481536

    I need the EXACT create index statement that you ran, the one that failed.

    p.s. If you're partitioning on dates, partition RIGHT, not LEFT. Partitioning left with dates is horrid, and your partition function allows for some dates to slip into the wrong partition, because there are valid dates between 2011-05-31 23:59:59 and 2011-06-01 00:00:00.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass