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 |
amitsharma
Starting Member
2 Posts |
Posted - 2008-06-18 : 06:15:02
|
hi i have created sfdata databse having craores of records in the table. now when i trying to insert some data in some tabel in sfdata databse, the sql server 2005 increses the size of mdf file on tempdb databse and becuse of thiis my c drive gets full. why thiis is incresing the size of tempdb databse mdf file however tehre no link b/w the databse i am working and the tempdb database. how can i remove the .mdf file of tempdb file |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-18 : 06:41:33
|
Put it this way, if you try to remove TempDB, you are no longer going to have a useable SQL Server.It really does depend on what you are trying to do for the insert. TempDB is used to store any information to make processing faster, obviously you are trying to insert far too many rows in one transaction and this is what is causing your problems. Try splitting your insert into batches. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 21:50:40
|
How did you insert data? That shouldn't cause tempdb grow like that usually. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-19 : 03:12:46
|
quote: Originally posted by amitsharma hi i have created sfdata databse having craores of records in the table. now when i trying to insert some data in some tabel in sfdata databse, the sql server 2005 increses the size of mdf file on tempdb databse and becuse of thiis my c drive gets full. why thiis is incresing the size of tempdb databse mdf file however tehre no link b/w the databse i am working and the tempdb database. how can i remove the .mdf file of tempdb file
Are you using temporary tables in your query and putting lots of data to them? |
|
|
|
|
|