Chowdary's (7/30/2014)
Dear Eirikur Eiriksson,How can i claim my space from that table without doing Compress, Can you pls give me some suggestions..
Regards
Chowdary....
Why is compression not an option? Because of SQL Server edition?
Another way to reduce size - aside from the obvious: deleting data - is to choose your column data types wisely.
Every byte saved counts.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP