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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-01-18 : 06:14:45
|
| Hi,I executed the below statement to determine the table size. This is what i got as output.sp_spaceused 'SAMPLE'name rows reserved data index_size unusedSAMPLE 32000 840 KB 832 KB 8 KB 0 KBHow to calculate the total size of a table? What components can i sum up and say this is the exact size of the table.Why i am asking this is because, i want to calculate the size of the logfile(.LDF)?Scenario,There is a table with 16 crore data and we are increasing the length of the column fromchar(5) to char(10). While doing the increase, the before and after image is being logged in .LDf file. Right?We are running the ALTER TABLE script but at it is running short of free space in disk drive and the operation is falling....If we can know how much actual/exact amount space occupied in the .LDF file, it would help us!I can go with SELECT INTO but the script is already there and i have to go with it!Example scenario, would be great.Thanks in Advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-18 : 09:41:22
|
| Kristen already showed you what to do here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138072 |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-01-23 : 10:58:55
|
| Thank You. |
|
|
|
|
|
|
Calculate table size and LDF size for txn success