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 ?

Thanks

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?

"Batzal via webservertalk.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:[color=darkred
]
>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 webservertalk.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: 
>