December 3, 2009 at 2:22 pm
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
December 4, 2009 at 12:34 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply