## How do we calculate the Space used per row

 Author Message krishnavamshi24 SSC Veteran Group: General Forum Members Points: 229 Visits: 199 Hi Everyone,Just have a doubt is there any way that we could calculate the space used per row.Thanks derek.colley Mr or Mrs. 500 Group: General Forum Members Points: 520 Visits: 603 It depends on the type of data you're storing. You will need a good handle on the datatypes used in SQL Server (start here: http://msdn.microsoft.com/en-us/library/ms187752.aspx ) to know the difference between, for example, CHAR and VARCHAR, TINYINT/SMALLINT/INT/BIGINT, etc. and how they store data differently.There isn't really a magic bullet for this, it's just some calculation required on your part. There are some interesting articles out there on LOB-handling (off-row data storage) and storage required for header data. But I would start by simply calculating the average length of data in a given table, i.e. this would get an average amount of characters for a particular column in a table:`CREATE TABLE dbo.test_table_12345 ( uid INT, this VARCHAR(20))INSERT INTO dbo.test_table_12345VALUES (1, 'afklda'), (2, 'fkalsdjflasd'), (3, 'fjasd'), (4, 'fkadlsjfladsjf'), (5, 'dalfj') SELECT AVG(LEN(this)) FROM dbo.test_table_12345`Then depending on the data type, you can work out byte storage costs if that's what you want, or aggregate it for multiple columns. ---Note to developers: CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1So why complicate your code AND MAKE MY JOB HARDER??!Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)My blog: http://uksqldba.blogspot.comVisit http://www.DerekColley.co.uk to find out more about me. BriPan SSC Journeyman Group: General Forum Members Points: 85 Visits: 296 even for avg Data Sizesp_spaceused TableNameOutput name    rows   reserved   data   index_size   unusedTableName   11    32 KB   8 KB   24 KB    0 KBthen reserved/rows gives avg data size