Table size estimation (MS SQL 2005)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Igor Nikitin » Table size estimation (MS SQL 2005)

Table size estimation (MS SQL 2005)

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Monday, April 20, 2009 3:07 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Table size estimation (MS SQL 2005)

Post #701008

pravallika.mca06

Posted Tuesday, November 10, 2009 4:56 AM

Forum 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

pravallika.mca06

Posted Tuesday, November 10, 2009 5:04 AM

Forum 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

pravallika.mca06

Posted Tuesday, November 10, 2009 11:21 PM

Forum 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

pravallika.mca06

Posted Thursday, November 12, 2009 6:20 AM

Forum 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

mi_ka_ze

Posted Tuesday, May 08, 2012 2:48 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 1:55 AM
Points: 10, Visits: 109

Just wanted to thanks you for the script :)

Post #1296294

« Prev Topic | Next Topic »

Permissions