Determine Table Size

14-Jul-0909 Leave a comment

EXECUTE sys.sp_spaceUsed ‘dbo.TableName’

To determine for more tables need to use a cursor. See below and other articles ( unchecked )http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx

 

Filed under SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

<span>%d</span> bloggers like this: