Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Table size estimation (MS SQL 2005) Expand / Collapse
Author
Message
Posted Monday, April 20, 2009 3:07 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Table size estimation (MS SQL 2005)
Post #701008
Posted Tuesday, November 10, 2009 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 14, 2009 8:15 AM
Points: 8, Visits: 25
Hi,

I have executed the updated CalcSpace procedure.
Still its not giving the accurate values for SQL server 2005 and 2008.

Can you please modify it so that it works for 2005 and 2008?

Thanks in advance.
Post #816405
Posted Tuesday, November 10, 2009 5:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 14, 2009 8:15 AM
Points: 8, Visits: 25
Hi,

How to caliculate the var usage coefficient for a table?

Can you please tell me the way to calicualte this.

Thanks in advance.
Post #816409
Posted Tuesday, November 10, 2009 11:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 14, 2009 8:15 AM
Points: 8, Visits: 25
Hi,

Please tell me how to caliculate the var_usage_cofficient which helps to estimate the table size.


Thanks in advance.
Post #816983
Posted Thursday, November 12, 2009 6:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 14, 2009 8:15 AM
Points: 8, Visits: 25
Hi Nikitin,

Can you please tell me how can i calicualte the column usage count which you mentioned to estimate the table size.

Thanks for your help...
Post #817773
Posted Tuesday, May 08, 2012 2:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:46 AM
Points: 17, Visits: 145
Just wanted to thanks you for the script :)
Post #1296294
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse