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

Available bytes for row expansion (adding columns) in a table Expand / Collapse
Author
Message
Posted Friday, February 8, 2008 3:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2008 1:47 PM
Points: 4, Visits: 5
Comments posted to this topic are about the item Available bytes for row expansion (adding columns) in a table
Post #453513
Posted Thursday, April 3, 2008 8:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Many 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 done

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #479237
Posted Thursday, February 19, 2009 4:07 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 9, 2010 2:56 AM
Points: 32, Visits: 58
Hi,
I don't understand the variable length computation. Why do you use the max aggregate and not the sum ?

Thanks




Patrick Duflot
Post #660165
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse