| Groups | Blog | Home |
sql server clients : Problem with big data transfer
SELECT top 90000 * from tablename order by 1 desc
is it working ? I am just woundering like your table is alright or not.... [quoted text, click to view] "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message news:erAp#B0SFHA.3156@TK2MSFTNGP15.phx.gbl... > yes, i run the SQL query SELECT top 90000 and it worked. > > i even put the data in two different tables and i managed to transfer them > > but when i try to transfer all in one go, it hangs > > one of my colleague find that > http://support.microsoft.com/?kbid=892205 > > > > can it be the cause ? > > > > > > > > > > "John" <joh@mailcity.com> wrote in message > news:%23crW6ozSFHA.3980@TK2MSFTNGP12.phx.gbl... > > First check your source table ..... can you retrieve more than 90000 row > > from source table ? > > > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > > news:eX91hsySFHA.584@TK2MSFTNGP15.phx.gbl... > > > When the "transfer" (UPDATE) statement fails what error do you receive? > I > > > am guessing that the drive with your data or log file on it is full. Do > > you > > > receive an error along the lines of "cannot allocate space...full?" > > > > > > -- > > > Keith > > > > > > > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > > > news:uM2vJkySFHA.2128@TK2MSFTNGP14.phx.gbl... > > > >I am transfering using UPDATE Table SET (SELECT ....) > > > > > > > > from one table to another table within the same server > > > > > > > > That s strange > > > > > > > > > > > > > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > > > > news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... > > > >> How are you transferring the data? > > > >> > > > >> I have used BCP, DTS and T-SQL to "transfer" data from one location > to > > > >> another. I have successfully transferred more than 10x the data you > > are > > > >> talking about. I used T-SQL for table-table transfer (within the > same > > > >> server) and DTS for server-server transfer. > > > >> > > > >> -- > > > >> Keith > > > >> > > > >> > > > >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > > > >> news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... > > > >> > Hi, > > > >> > > > > >> > > > > >> > I have MSSQl 2000 , SP3 with WIn2000 > > > >> > > > > >> > when I transfer from one table to another, 115852 records, le > server > > > >> > hangs. > > > >> > > > > >> > I tried with 70000 records and it worked. even with 90000 records. > > > >> > > > > >> > With more than 90000 records, the server hangs. > > > >> > > > > >> > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? > > > >> > > > > >> > Thanks for your help > > > >> > > > > >> > Olivier > > > >> > > > > >> > > > > >> > > > > >> > > > >> > > > > > > > > > > > > > > > > > > > >
this command is working
My server is using Hyper threading, is this ring a bell ? [quoted text, click to view] "John" <joh@mailcity.com> wrote in message news:etGP8E0SFHA.3184@TK2MSFTNGP14.phx.gbl... > SELECT top 90000 * from tablename order by 1 desc > > is it working ? I am just woundering like your table is alright or not.... > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > news:erAp#B0SFHA.3156@TK2MSFTNGP15.phx.gbl... > > yes, i run the SQL query SELECT top 90000 and it worked. > > > > i even put the data in two different tables and i managed to transfer them > > > > but when i try to transfer all in one go, it hangs > > > > one of my colleague find that > > http://support.microsoft.com/?kbid=892205 > > > > > > > > can it be the cause ? > > > > > > > > > > > > > > > > > > > > "John" <joh@mailcity.com> wrote in message > > news:%23crW6ozSFHA.3980@TK2MSFTNGP12.phx.gbl... > > > First check your source table ..... can you retrieve more than 90000 > row > > > from source table ? > > > > > > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > > > news:eX91hsySFHA.584@TK2MSFTNGP15.phx.gbl... > > > > When the "transfer" (UPDATE) statement fails what error do you > receive? > > I > > > > am guessing that the drive with your data or log file on it is full. > Do > > > you > > > > receive an error along the lines of "cannot allocate space...full?" > > > > > > > > -- > > > > Keith > > > > > > > > > > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > > > > news:uM2vJkySFHA.2128@TK2MSFTNGP14.phx.gbl... > > > > >I am transfering using UPDATE Table SET (SELECT ....) > > > > > > > > > > from one table to another table within the same server > > > > > > > > > > That s strange > > > > > > > > > > > > > > > > > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > > > > > news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... > > > > >> How are you transferring the data? > > > > >> > > > > >> I have used BCP, DTS and T-SQL to "transfer" data from one location > > to > > > > >> another. I have successfully transferred more than 10x the data > you > > > are > > > > >> talking about. I used T-SQL for table-table transfer (within the > > same > > > > >> server) and DTS for server-server transfer. > > > > >> > > > > >> -- > > > > >> Keith > > > > >> > > > > >> > > > > >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > > > > >> news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... > > > > >> > Hi, > > > > >> > > > > > >> > > > > > >> > I have MSSQl 2000 , SP3 with WIn2000 > > > > >> > > > > > >> > when I transfer from one table to another, 115852 records, le > > server > > > > >> > hangs. > > > > >> > > > > > >> > I tried with 70000 records and it worked. even with 90000 > records. > > > > >> > > > > > >> > With more than 90000 records, the server hangs. > > > > >> > > > > > >> > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? > > > > >> > > > > > >> > Thanks for your help > > > > >> > > > > > >> > Olivier > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Hi
Probably not. Does sp_who2 show increasing CPU and IO whilst the process has "hung"? Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message news:%237TiTK0SFHA.612@TK2MSFTNGP12.phx.gbl... > this command is working > > My server is using Hyper threading, is this ring a bell ? > > > > > "John" <joh@mailcity.com> wrote in message > news:etGP8E0SFHA.3184@TK2MSFTNGP14.phx.gbl... >> SELECT top 90000 * from tablename order by 1 desc >> >> is it working ? I am just woundering like your table is alright or >> not.... >> >> >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message >> news:erAp#B0SFHA.3156@TK2MSFTNGP15.phx.gbl... >> > yes, i run the SQL query SELECT top 90000 and it worked. >> > >> > i even put the data in two different tables and i managed to transfer > them >> > >> > but when i try to transfer all in one go, it hangs >> > >> > one of my colleague find that >> > http://support.microsoft.com/?kbid=892205 >> > >> > >> > >> > can it be the cause ? >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > "John" <joh@mailcity.com> wrote in message >> > news:%23crW6ozSFHA.3980@TK2MSFTNGP12.phx.gbl... >> > > First check your source table ..... can you retrieve more than 90000 >> row >> > > from source table ? >> > > >> > > >> > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message >> > > news:eX91hsySFHA.584@TK2MSFTNGP15.phx.gbl... >> > > > When the "transfer" (UPDATE) statement fails what error do you >> receive? >> > I >> > > > am guessing that the drive with your data or log file on it is >> > > > full. >> Do >> > > you >> > > > receive an error along the lines of "cannot allocate space...full?" >> > > > >> > > > -- >> > > > Keith >> > > > >> > > > >> > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message >> > > > news:uM2vJkySFHA.2128@TK2MSFTNGP14.phx.gbl... >> > > > >I am transfering using UPDATE Table SET (SELECT ....) >> > > > > >> > > > > from one table to another table within the same server >> > > > > >> > > > > That s strange >> > > > > >> > > > > >> > > > > >> > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message >> > > > > news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... >> > > > >> How are you transferring the data? >> > > > >> >> > > > >> I have used BCP, DTS and T-SQL to "transfer" data from one > location >> > to >> > > > >> another. I have successfully transferred more than 10x the data >> you >> > > are >> > > > >> talking about. I used T-SQL for table-table transfer (within >> > > > >> the >> > same >> > > > >> server) and DTS for server-server transfer. >> > > > >> >> > > > >> -- >> > > > >> Keith >> > > > >> >> > > > >> >> > > > >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message >> > > > >> news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... >> > > > >> > Hi, >> > > > >> > >> > > > >> > >> > > > >> > I have MSSQl 2000 , SP3 with WIn2000 >> > > > >> > >> > > > >> > when I transfer from one table to another, 115852 records, le >> > server >> > > > >> > hangs. >> > > > >> > >> > > > >> > I tried with 70000 records and it worked. even with 90000 >> records. >> > > > >> > >> > > > >> > With more than 90000 records, the server hangs. >> > > > >> > >> > > > >> > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? >> > > > >> > >> > > > >> > Thanks for your help >> > > > >> > >> > > > >> > Olivier >> > > > >> > >> > > > >> > >> > > > >> > >> > > > >> >> > > > >> >> > > > > >> > > > > >> > > > >> > > > >> > > >> > > >> > >> > >> >> > >
I am transfering using UPDATE Table SET (SELECT ....)
from one table to another table within the same server That s strange [quoted text, click to view] "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... > How are you transferring the data? > > I have used BCP, DTS and T-SQL to "transfer" data from one location to > another. I have successfully transferred more than 10x the data you are > talking about. I used T-SQL for table-table transfer (within the same > server) and DTS for server-server transfer. > > -- > Keith > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... > > Hi, > > > > > > I have MSSQl 2000 , SP3 with WIn2000 > > > > when I transfer from one table to another, 115852 records, le server > > hangs. > > > > I tried with 70000 records and it worked. even with 90000 records. > > > > With more than 90000 records, the server hangs. > > > > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? > > > > Thanks for your help > > > > Olivier > > > > > > > >
Hi,
I have MSSQl 2000 , SP3 with WIn2000 when I transfer from one table to another, 115852 records, le server hangs. I tried with 70000 records and it worked. even with 90000 records. With more than 90000 records, the server hangs. Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? Thanks for your help Olivier
yes, i run the SQL query SELECT top 90000 and it worked.
i even put the data in two different tables and i managed to transfer them but when i try to transfer all in one go, it hangs one of my colleague find that http://support.microsoft.com/?kbid=892205 can it be the cause ? [quoted text, click to view] "John" <joh@mailcity.com> wrote in message news:%23crW6ozSFHA.3980@TK2MSFTNGP12.phx.gbl... > First check your source table ..... can you retrieve more than 90000 row > from source table ? > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > news:eX91hsySFHA.584@TK2MSFTNGP15.phx.gbl... > > When the "transfer" (UPDATE) statement fails what error do you receive? I > > am guessing that the drive with your data or log file on it is full. Do > you > > receive an error along the lines of "cannot allocate space...full?" > > > > -- > > Keith > > > > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > > news:uM2vJkySFHA.2128@TK2MSFTNGP14.phx.gbl... > > >I am transfering using UPDATE Table SET (SELECT ....) > > > > > > from one table to another table within the same server > > > > > > That s strange > > > > > > > > > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > > > news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... > > >> How are you transferring the data? > > >> > > >> I have used BCP, DTS and T-SQL to "transfer" data from one location to > > >> another. I have successfully transferred more than 10x the data you > are > > >> talking about. I used T-SQL for table-table transfer (within the same > > >> server) and DTS for server-server transfer. > > >> > > >> -- > > >> Keith > > >> > > >> > > >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > > >> news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... > > >> > Hi, > > >> > > > >> > > > >> > I have MSSQl 2000 , SP3 with WIn2000 > > >> > > > >> > when I transfer from one table to another, 115852 records, le server > > >> > hangs. > > >> > > > >> > I tried with 70000 records and it worked. even with 90000 records. > > >> > > > >> > With more than 90000 records, the server hangs. > > >> > > > >> > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? > > >> > > > >> > Thanks for your help > > >> > > > >> > Olivier > > >> > > > >> > > > >> > > > >> > > >> > > > > > > > > > > > >
How are you transferring the data?
I have used BCP, DTS and T-SQL to "transfer" data from one location to another. I have successfully transferred more than 10x the data you are talking about. I used T-SQL for table-table transfer (within the same server) and DTS for server-server transfer. -- Keith [quoted text, click to view] "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... > Hi, > > > I have MSSQl 2000 , SP3 with WIn2000 > > when I transfer from one table to another, 115852 records, le server > hangs. > > I tried with 70000 records and it worked. even with 90000 records. > > With more than 90000 records, the server hangs. > > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? > > Thanks for your help > > Olivier > > >
When the "transfer" (UPDATE) statement fails what error do you receive? I
am guessing that the drive with your data or log file on it is full. Do you receive an error along the lines of "cannot allocate space...full?" -- Keith [quoted text, click to view] "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message news:uM2vJkySFHA.2128@TK2MSFTNGP14.phx.gbl... >I am transfering using UPDATE Table SET (SELECT ....) > > from one table to another table within the same server > > That s strange > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... >> How are you transferring the data? >> >> I have used BCP, DTS and T-SQL to "transfer" data from one location to >> another. I have successfully transferred more than 10x the data you are >> talking about. I used T-SQL for table-table transfer (within the same >> server) and DTS for server-server transfer. >> >> -- >> Keith >> >> >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message >> news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... >> > Hi, >> > >> > >> > I have MSSQl 2000 , SP3 with WIn2000 >> > >> > when I transfer from one table to another, 115852 records, le server >> > hangs. >> > >> > I tried with 70000 records and it worked. even with 90000 records. >> > >> > With more than 90000 records, the server hangs. >> > >> > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? >> > >> > Thanks for your help >> > >> > Olivier >> > >> > >> > >> >> > >
First check your source table ..... can you retrieve more than 90000 row
from source table ? [quoted text, click to view] "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message news:eX91hsySFHA.584@TK2MSFTNGP15.phx.gbl... > When the "transfer" (UPDATE) statement fails what error do you receive? I > am guessing that the drive with your data or log file on it is full. Do you > receive an error along the lines of "cannot allocate space...full?" > > -- > Keith > > > "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > news:uM2vJkySFHA.2128@TK2MSFTNGP14.phx.gbl... > >I am transfering using UPDATE Table SET (SELECT ....) > > > > from one table to another table within the same server > > > > That s strange > > > > > > > > "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message > > news:eC2qgcySFHA.2324@TK2MSFTNGP10.phx.gbl... > >> How are you transferring the data? > >> > >> I have used BCP, DTS and T-SQL to "transfer" data from one location to > >> another. I have successfully transferred more than 10x the data you are > >> talking about. I used T-SQL for table-table transfer (within the same > >> server) and DTS for server-server transfer. > >> > >> -- > >> Keith > >> > >> > >> "oLiVieR CheNeSoN" <ocheneson@hotmail.com> wrote in message > >> news:uNrXWVySFHA.3176@TK2MSFTNGP09.phx.gbl... > >> > Hi, > >> > > >> > > >> > I have MSSQl 2000 , SP3 with WIn2000 > >> > > >> > when I transfer from one table to another, 115852 records, le server > >> > hangs. > >> > > >> > I tried with 70000 records and it worked. even with 90000 records. > >> > > >> > With more than 90000 records, the server hangs. > >> > > >> > Any idea ? It might be a bug in MSSQLsvr ? any known bugs ? > >> > > >> > Thanks for your help > >> > > >> > Olivier > >> > > >> > > >> > > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |