Problems with DB 70 GB

hello,
Im trying to update millions of records , to a table , and the SQL SERVER ,
go too slow ?
how can I do ?
I have only one datafile , can i split ? It will increase the speed ?
ThanksYou might be able to break the update into more manageable pieces with a
where clause. It's tough to know how to help you without more information.
Can you post the update query?
"Batzal via droptable.com" wrote:

> hello,
> Im trying to update millions of records , to a table , and the SQL SERV
ER ,
> go too slow ?
> how can I do ?
> I have only one datafile , can i split ? It will increase the speed ?
> Thanks
>|||I Have a table with 30 Millions of rows , and I must to add, 12 Millions .
The query is :
Insert into Table1
Select *
from TableTemp
This query works good , when i put a where clause , but if i want to insert
all the rows , it dont work.
I Dont know what to do , Split the Database ? This Database , has 70 GB .
Thanks
fnguy wrote:[vbcol=seagreen]
>You might be able to break the update into more manageable pieces with a
>where clause. It's tough to know how to help you without more information.
>Can you post the update query?
>
>[quoted text clipped - 5 lines]|||You might be running out of log space or something similar such as server
resources. I'd suggest you get a dba in their to look at and review the
process for you. He / She should be able to resolve this easily in a day.
But be forwarned that you may hear something like "You need to drop your
non-clustered indexes first", "You need to get users out of the database
first", etc.
"Batzal via droptable.com" wrote:

> I Have a table with 30 Millions of rows , and I must to add, 12 Millions .
> The query is :
> Insert into Table1
> Select *
> from TableTemp
> This query works good , when i put a where clause , but if i want to inser
t
> all the rows , it dont work.
> I Dont know what to do , Split the Database ? This Database , has 70 GB .
> Thanks
> fnguy wrote:
>