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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Moving large record from a view to a single table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-30 : 09:25:58
DelanoJr writes "Hi All,
I have a view that contains 30 million records.I want to move the view to a table in my database using DTS,but it is taking a lot of time,and making my tempdb to grow fast in giga bytes.Please is there anyway i can copy this view into the table easily in minutes.The view structure and the table structure are the same.Also, how can I index a view and can I add unique key to a view.

Thanks All in advance.
Mokah"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-30 : 09:29:59
Why do you want to do this? You dont need to do this which is meaningless
Just use the view for DMLs

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -