|
Home > Archive > MS SQL Server > October 2005 > Problems with DB 70 GB
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problems with DB 70 GB
|
|
| Batzal via SQLMonster.com 2005-10-28, 9:23 am |
| 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 SERVER ,
> go too slow ?
> how can I do ?
>
> I have only one datafile , can i split ? It will increase the speed ?
>
> Thanks
>
| |
| Batzal via SQLMonster.com 2005-10-28, 11:23 am |
| 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 insert
> all the rows , it dont work.
>
> I Dont know what to do , Split the Database ? This Database , has 70 GB .
>
> Thanks
>
> fnguy wrote:
>
|
|
|
|
|