Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-09-11 : 03:33:44
|
| Hi, I have a problem with insertion. when i used to insert data into another table (which is having 7Cr records with 70 columns and size is 8GB. ), data is inserting very slow just like 100 rows and 200 rows. Any body Know what is the problem in this scenario. thanks in advance...... :)Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2012-09-11 : 04:52:10
|
| Not enough infoMaybe too many indecs, triggers, log file dimension ? |
 |
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2012-09-11 : 05:15:39
|
| There is no Indexes on this table and recovery Modal is Simple. Logfile 10% and datafile 15% autogrowth. and the files are located in different drivers.Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2012-09-11 : 05:32:12
|
| ok what about de code that insert those rows ?table structure |
|
|
|
Jayam.cnu
Starting Member
45 Posts |
Posted - 2012-09-11 : 05:39:09
|
| Yes... Just like for example :: select * into #emptable from Master_Empinfo Insert into Maintable select eid,ename,eaddr from #emptable Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2012-09-11 : 06:02:59
|
| transactions?can you change the autogrow , in a fix file growth ? (10,50,100 MB) |
|
|
|
|
|
|
Problem with Inserting data into Huge table