SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Igor Nikitin / Table size estimation (MS SQL 2005) / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 20:26:59 GMT20RE: Table size estimation (MS SQL 2005)http://www.sqlservercentral.com/Forums/Topic701008-1536-1.aspxJust wanted to thanks you for the script :)Tue, 08 May 2012 02:48:44 GMTmi_ka_zeRE: Table size estimation (MS SQL 2005)http://www.sqlservercentral.com/Forums/Topic701008-1536-1.aspxHi 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...Thu, 12 Nov 2009 06:20:58 GMTpravallika.mca06RE: Table size estimation (MS SQL 2005)http://www.sqlservercentral.com/Forums/Topic701008-1536-1.aspxHi,Please tell me how to caliculate the var_usage_cofficient which helps to estimate the table size.Thanks in advance.Tue, 10 Nov 2009 23:21:56 GMTpravallika.mca06RE: Table size estimation (MS SQL 2005)http://www.sqlservercentral.com/Forums/Topic701008-1536-1.aspxHi,How to caliculate the var usage coefficient for a table?Can you please tell me the way to calicualte this.Thanks in advance.Tue, 10 Nov 2009 05:04:24 GMTpravallika.mca06RE: Table size estimation (MS SQL 2005)http://www.sqlservercentral.com/Forums/Topic701008-1536-1.aspxHi,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.Tue, 10 Nov 2009 04:56:30 GMTpravallika.mca06Table size estimation (MS SQL 2005)http://www.sqlservercentral.com/Forums/Topic701008-1536-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Size+estimation/66664/">Table size estimation (MS SQL 2005)</A>[/B]Mon, 20 Apr 2009 15:07:02 GMTSite Owners