Moving data out of a partion

  • Guys i was asked this question in an interview so am gonna do the best i can to rephrase it.Here is the question;i was asked how i could move old data in terms of lets say 2 week old data out of a partition that has been created and leave the current data on the partition which would be more than 2 weeks old, i hope i have tried to phrase it the best way, can someone tell me how to do this. Any ideas are welcomed. Thank you

  • Please don't cross post. It just wastes peoples time and fragments replies. There's no partitioning on SQL 2000, so putting this in the SQL 2000 forum is inappropriate anyway

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic828512-360-1.aspx

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply