Hi

As you are on SQL 2005 you could use table partitions. Your exact solution
is very much dependent on the application and system you have for it's
design.

John

"Bulent" <bulentgucuk@gmail.com> wrote in message
news:7f32be14-e754-4379-9a28-54697308a59a@c65g2000hsa.googlegroups.com...
> In my envrionment not all the tables have datetime field that
> indicates when the row is created or updated. Coming up a DW project
> that will be implemented I would like to ask the community what kind
> of techniques they use for Incremental data loading. There are some
> tables that has over 20 million rows that I don't want to do full load.