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 |
|
rayeesh
Starting Member
2 Posts |
 Posted - 2007-03-16 : 08:47:30
|
| sir i have a problem regarding Transaction log i have a function written in .netwithin that i had begun a transcation and within that transaction i m doing lot of deletion and insertion work in sql query embeded withi in query more than 4 laks insertion and deletion work then commited the Transaction this function taking time while executingi have checked Log file of Sql server that is not also too bigits mere 4 GBthe problem is when i take fresh database its executes tremandously faster now wat can i do plz help |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-16 : 13:11:12
|
| How much is 4 laks, and how many insertions and deletions are there in the "fresh" database? |
 |
|
|
|
|
|
Transaction problem