SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by ruchir / Available bytes for row expansion (adding columns) in a table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 22:00:37 GMT20RE: Available bytes for row expansion (adding columns) in a tablehttp://www.sqlservercentral.com/Forums/Topic453513-1197-1.aspxHi,I don't understand the variable length computation. Why do you use the max aggregate and not the sum ? ThanksThu, 19 Feb 2009 04:07:41 GMTPatrick DuflotRE: Available bytes for row expansion (adding columns) in a tablehttp://www.sqlservercentral.com/Forums/Topic453513-1197-1.aspxMany thanks for your script. In particular the inclusion of the 'null bit map' - something I did not really consider. Have taken the liberty of adding your function to my bag of tools. Again thanks for a job well doneThu, 03 Apr 2008 08:15:54 GMTbitbucket-25253Available bytes for row expansion (adding columns) in a tablehttp://www.sqlservercentral.com/Forums/Topic453513-1197-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SQL+Server+2005/62190/">Available bytes for row expansion (adding columns) in a table</A>[/B]Fri, 08 Feb 2008 15:30:45 GMTruchir-628038