Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saurabhsrivastava
Posting Yak Master
216 Posts |
 Posted - 2010-02-18 : 01:12:47
|
| I have an ETL load running every night. I want to partition table and use SWITCH for active data to be in latest partition when load operation completes, using 0 and 1 logic in where clause. O denotes old ETL run and 1 latest. Any ideas on how to implement this logic will be appreciated. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-02-22 : 10:57:57
|
None...except you can now become a preferred buyer of any data storage vendor since you'll have 2 copies of data at all times in your database. Given that you are considering going down this route, it is fair to guess that this is not an insignificant amount of data. Maybe your dollars would be better spent on not loading/finding a better loading route than you propose.I'm working on a similar project (vendor supplied and already installed) and the concept sucks along with the implementation.Good luck with the torture. |
 |
|
|
|
|
|
Table Partitioning based on 0 and 1 logic