Estimating SQL Server 2005 Table Size 2

[Skittle]

Has the calculation changed between SQL 2000 and SQL 2005 on how to calculate a tables estimated storage size.

In SQL Server 2000 it is well described at

http://msdn2.microsoft.com/en-us/library/aa933068(SQL.80).aspx

but I can't find a reference anywhere for SQL 2005. It's one of the objectives for the MCTS exam I'm taking (Eek!) on Tuesday.

At the back of my mind I seem to remember something about variable fields now being treated differently in SQL 2005.

Many thanks.





Dazed and confused

 

[mrdenny]

That formula should continue to work fine in SQL 2005.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

Skittle,
If you search BOL 2005 for estimate table size you can get a little more info on how to calculate a heap table, clusterd and non clusterd indexes.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Skittle]

Thanks chaps.

Dazed and confused

 

[Skittle]

..by the way Mr Denny...I think you are becoming a certification addict.
Your certs are getting bigger than your postings! )
You should change your handle to 'Captain Certification', the IT superhero!

...and no...its not because I'm jealous. Aheuum!.

Dazed and confused

 

[mrdenny]

No problem.

Yeah, I've picked up a few certs. I've only got 3 more that I'm working on. Yeah, the sig file is starting to get a little long.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com