princa (5/7/2012)

---

Good question, it's actually the same scenario I am facing right now!!!
But I still have some questions:
#1 - I am using a partitioned view to union two tables, one is original table, one is backup table. So every time I will need to backup original table to backup table, and use partitioned view to union them then will return the same result as i query only original table.
#2 - Then I will delete from original table and then insert all new data. While I am performing this step, eventhough I use with (nolock) on my partitioned view with select statement, it will still be locked until the insert process is done, the same behavior like Truncate.

Am I doing something wrong here?