Tags: database, microsoft, mysql, oracle, server, size, sql, table

Check Table Size

On Database » Microsoft SQL Server

1,083 words with 2 Comments; publish: Mon, 02 Jun 2008 01:44:00 GMT; (250156.25, « »)

Hello,

How can i check the size of one table ?

Best regards

All Comments

Leave a comment...

  • 2 Comments
    • Try sp_spaceused

      --

      HTH,

      Vyas, MVP (SQL Server)

      http://vyaskn.tripod.com/

      Is .NET important for a database professional?

      http://vyaskn.tripod.com/poll.htm

      "CC&JM" <anonymous.sqlserver.questionfor.info.discussions.microsoft.com> wrote in message

      news:fcda01c43e88$c17437b0$a001280a.sqlserver.questionfor.info.phx.gbl...

      Hello,

      How can i check the size of one table ?

      Best regards

      #1; Mon, 02 Jun 2008 01:46:00 GMT
    • Hi,

      use dbname

      go

      sp_spaceused <table_name>

      or

      use <dbname>

      go

      sp_spaceused <table_name>, .sqlserver.questionfor.info.updateusage ='true'

      .sqlserver.questionfor.info.updateusage will correct the inconsistencies in indexes and give you much

      more perfected value.

      Thanks

      Hari

      MCDBA

      "CC&JM" <anonymous.sqlserver.questionfor.info.discussions.microsoft.com> wrote in message

      news:fcda01c43e88$c17437b0$a001280a.sqlserver.questionfor.info.phx.gbl...

      > Hello,

      > How can i check the size of one table ?

      > Best regards

      #2; Mon, 02 Jun 2008 01:47:00 GMT