Transform/transfer 50Gb - how to do it fast?
- From: B D Jensen <bjorn.d.jensen@xxxxxxxxx>
- Date: 27 Apr 2007 22:54:56 -0700
Hello!
I have an big table with 50Gb data, written som functions
that cleanup data and want to do something like this
insert into newtable
select id, func1(col1), func2(col2)
from oldtable;
I'm also plan to make newtable partioned (before insert).
But how could i get the insert as fast as possible?
Greetings
Bjorn D. Jensen
.
- Follow-Ups:
- Re: Transform/transfer 50Gb - how to do it fast?
- From: Erland Sommarskog
- Re: Transform/transfer 50Gb - how to do it fast?
- From: Mork69
- Re: Transform/transfer 50Gb - how to do it fast?
- Prev by Date: Re: getdate() problem: where is the time taken from ?
- Next by Date: SQL Server Annoying popup upon boot
- Previous by thread: LOG Explorer
- Next by thread: Re: Transform/transfer 50Gb - how to do it fast?
- Index(es):