Estimate the size of a Table

• Jampandu

  Ten Centuries

  Points: 1062

  More actions

  February 4, 2015 at 8:37 am

  #303030

  Hi Experts,

  I have a table like below,

  CREATE TABLE Student

  (

  Id BIGINT not null

  ,Name NCHAR(20) not Null

  ,Branch NVARCHAR (64) null

  )

  The table contains : 100000 rows .

  Can you please help me in getting details of below

  1)Number of rows in a data page

  2)Total number of pages required for the table

  3)Total Table size in KB or MB

  4)Total file size in Kb or MB

  Thanks!

• Jampandu

  Ten Centuries

  Points: 1062

  More actions

  February 4, 2015 at 8:58 am

  #1775360

  Please ignore this as created a new thread in SQL Server 2008 - General forum for the same.