SQL Server Performance Forum – Threads Archive
Abnormal table size
Hi pple,<br />I have this tables with 1.2 million records and it’s 16gb in size.The same table in another database is 500MB and it has 4.7 million records.Field sizes are the same.<br />What could be the problem><img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />lease Help.Are there any TEXT/NTEXT or IMAGE columns? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
No there are None.The largest Column is Varchar(150)
what is the full and complete output of sp_spaceused TableName
What is the size of Transaction log for that database? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
The transaction is indeed very small.It’s 64MB.
JoeChang I am yet to get the details of sp_spaceused cheers
.. for optimum results run as SP_SPACEUSED @UPDATEUSAGE=’TRUE. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
The unused space is actually over 10 gb.How do i recover it??
You can use DBCC SHRINKFILE to do so, but before that think twice.
Do you have any disk space issues? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
What indexes do you have on the table? Is any fragmented?
]]>