Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Maximum row size (http://www.go4expert.com/forums/maximum-row-size-t13324/)

Sugsy 27Aug2008 18:48

Maximum row size
 
Please can someone tell me how I can find the maximum row size for a table in SQL Server 2000.

We've recently had issues with lack of space and drive on which data files reside is badly fragmented.

Was wondering if this fragging occurred because row sizes were exceeding the 8KB that allows them to fit into a page.

If anyone could give me some info on this topic & show me how to find Max row size would be very grateful.

Sugsy


All times are GMT +5.5. The time now is 19:53.