• How can this be done for every field in a table (at once)?

    g

    select max(datalength(YourColumn)) from YourTable