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 droptable.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
>
|||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 insert
> all the rows , it dont work.
> I Dont know what to do , Split the Database ? This Database , has 70 GB .
> Thanks
> fnguy wrote:
>
Showing posts with label slow. Show all posts
Showing posts with label slow. Show all posts
Wednesday, March 7, 2012
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:
>
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:
>
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 SQLMonster.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
>|||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:
>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?
>> hello,
>[quoted text clipped - 5 lines]
>> Thanks|||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 SQLMonster.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:
> >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?
> >
> >> hello,
> >>
> >[quoted text clipped - 5 lines]
> >>
> >> Thanks
>
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 SQLMonster.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
>|||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:
>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?
>> hello,
>[quoted text clipped - 5 lines]
>> Thanks|||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 SQLMonster.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:
> >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?
> >
> >> hello,
> >>
> >[quoted text clipped - 5 lines]
> >>
> >> Thanks
>
Saturday, February 25, 2012
Problems with "Local connections only"
Hello,
Our application is running very slow, we have an application installed
on (XP professional or Windows 2003) running SQL Server 2005 or
SQLExpress on the same pc.
We have realized that if we change "Local connections only" for "Local
and remote connections", our application (VB6) runs much faster
(Normally I'd say).
We need to run our application in the same computer where the server
is running with "Local connections only".
Can anyone help to us?
Thanks,
Laslo
Let's see your ConnectString.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"lalo_losla" <lalo_losla@.hotmail.com> wrote in message
news:1182795665.411020.31170@.c77g2000hse.googlegro ups.com...
> Hello,
> Our application is running very slow, we have an application installed
> on (XP professional or Windows 2003) running SQL Server 2005 or
> SQLExpress on the same pc.
> We have realized that if we change "Local connections only" for "Local
> and remote connections", our application (VB6) runs much faster
> (Normally I'd say).
> We need to run our application in the same computer where the server
> is running with "Local connections only".
> Can anyone help to us?
> Thanks,
> Laslo
>
|||Conn As ADODB.Connection
Conn.Open ODBCName, Login, Pwd
Our application is running very slow, we have an application installed
on (XP professional or Windows 2003) running SQL Server 2005 or
SQLExpress on the same pc.
We have realized that if we change "Local connections only" for "Local
and remote connections", our application (VB6) runs much faster
(Normally I'd say).
We need to run our application in the same computer where the server
is running with "Local connections only".
Can anyone help to us?
Thanks,
Laslo
Let's see your ConnectString.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"lalo_losla" <lalo_losla@.hotmail.com> wrote in message
news:1182795665.411020.31170@.c77g2000hse.googlegro ups.com...
> Hello,
> Our application is running very slow, we have an application installed
> on (XP professional or Windows 2003) running SQL Server 2005 or
> SQLExpress on the same pc.
> We have realized that if we change "Local connections only" for "Local
> and remote connections", our application (VB6) runs much faster
> (Normally I'd say).
> We need to run our application in the same computer where the server
> is running with "Local connections only".
> Can anyone help to us?
> Thanks,
> Laslo
>
|||Conn As ADODB.Connection
Conn.Open ODBCName, Login, Pwd
Labels:
application,
connections,
database,
installedon,
local,
microsoft,
mysql,
oracle,
orsqlexpress,
professional,
running,
server,
slow,
sql,
windows
Problems with "Local connections only"
Hello,
Our application is running very slow, we have an application installed
on (XP professional or Windows 2003) running SQL Server 2005 or
SQLExpress on the same pc.
We have realized that if we change "Local connections only" for "Local
and remote connections", our application (VB6) runs much faster
(Normally I'd say).
We need to run our application in the same computer where the server
is running with "Local connections only".
Can anyone help to us?
Thanks,
LasloLet's see your ConnectString.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"lalo_losla" <lalo_losla@.hotmail.com> wrote in message
news:1182795665.411020.31170@.c77g2000hse.googlegroups.com...
> Hello,
> Our application is running very slow, we have an application installed
> on (XP professional or Windows 2003) running SQL Server 2005 or
> SQLExpress on the same pc.
> We have realized that if we change "Local connections only" for "Local
> and remote connections", our application (VB6) runs much faster
> (Normally I'd say).
> We need to run our application in the same computer where the server
> is running with "Local connections only".
> Can anyone help to us?
> Thanks,
> Laslo
>|||Conn As ADODB.Connection
Conn.Open ODBCName, Login, Pwd
Our application is running very slow, we have an application installed
on (XP professional or Windows 2003) running SQL Server 2005 or
SQLExpress on the same pc.
We have realized that if we change "Local connections only" for "Local
and remote connections", our application (VB6) runs much faster
(Normally I'd say).
We need to run our application in the same computer where the server
is running with "Local connections only".
Can anyone help to us?
Thanks,
LasloLet's see your ConnectString.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"lalo_losla" <lalo_losla@.hotmail.com> wrote in message
news:1182795665.411020.31170@.c77g2000hse.googlegroups.com...
> Hello,
> Our application is running very slow, we have an application installed
> on (XP professional or Windows 2003) running SQL Server 2005 or
> SQLExpress on the same pc.
> We have realized that if we change "Local connections only" for "Local
> and remote connections", our application (VB6) runs much faster
> (Normally I'd say).
> We need to run our application in the same computer where the server
> is running with "Local connections only".
> Can anyone help to us?
> Thanks,
> Laslo
>|||Conn As ADODB.Connection
Conn.Open ODBCName, Login, Pwd
Labels:
application,
connections,
database,
installedon,
local,
microsoft,
mysql,
oracle,
orsqlexpress,
professional,
running,
server,
slow,
sql,
windows
Subscribe to:
Posts (Atom)