arrjay (9/30/2014)
Apologise to keep this going but I was wondering why SQL qould not more the MAX field (the field that i'm updating) onto a separate page? Thanks All!!
I'm wondering the same myself! Unless my arithmetic is out I calculated the maximum size of the row as just under 6,000 bytes excluding the MAX field. I though SQL would automatically move the field out if required, perhaps it isn't doing that.
Have you had chance to test changing that table option?