Hello !! How are you doing ?

I hope this article can help you in your question.

http://www.sqlservercentral.com/scripts/Variables/63345/

Best Regards!

Shin-Iti.

If it really are a problem to be solved in your environment, you should try to trace it using the Performance and SQL Profiler to find out the queries that...

It could be due to fragmentation. If your table is used for a lot of insert/delete and also is a heap table, you can expect this kind of behavior. Better...

Hummm... you are right. I gonna do it.

Anyway, I will not scape from the shrink to release the unused space after spread the rows in smaller tables. I was checking...

As Jeff already told, using DBCC SHOWCONTIG can give you a good idea about the status of fragmentation.

You can also use the "WITH TABLERESULTS" and "ALL_INDEXES" parameters.

DBCC SHOWCONTIG('TABLE') WITH TABLERESULTS,...