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 |
|
pmotewar
Yak Posting Veteran
62 Posts |
 Posted - 2009-05-11 : 03:33:03
|
| Hi,i m new to sql server , i m used begin transaction... commit transaction block. but because of this my hard disk space is increased whenever i execute the procedures. how can i release this space or how can i overcome this problem.Pankaj |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-05-11 : 03:42:25
|
| What do you mean 'hard drive space increased'? Are the SQL database files growing large? If so, which ones?The post title referred to memory, are you trying to release memory or disk space?--Gail ShawSQL Server MVP |
 |
|
|
pmotewar
Yak Posting Veteran
62 Posts |
Posted - 2009-05-11 : 03:46:20
|
quote:
Originally posted by GilaMonster
What do you mean 'hard drive space increased'? Are the SQL database files growing large? If so, which ones?The post title referred to memory, are you trying to release memory or disk space?--Gail ShawSQL Server MVP
thanks for reply,its disk space. my SQL database files growing large. and i think it is due to begin transaction.. commit transaction block.Pankaj |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-05-11 : 09:32:13
|
| Which files? If it's the ldf file, read this article http://www.sqlservercentral.com/articles/64582/It's not due to begin tran ... commit, unless you sometimes start transactions and never commit them. All SQL commands are in implicit transactions if you don't wrap them in explicit transactions--Gail ShawSQL Server MVP |
|
|
|
|
|
|
How to release memory