Is there a way to increase the cbMax for a long binary column? I'm pretty sure I can get what I need by adding a new column and combine the two at run time, but it's obviously not as clean.
Related, is there any cost to just specifying the limit to the physical max for this new column? I'd like to avoid coming back to this issue in the future if it's decided that the new limit isn't large enough again. Certainly I would not get any safety checks if I unintentionally try to store a value that exceeds my intended max, but it's fine for me to take that risk on myself.
Is there a way to increase the
cbMaxfor a long binary column? I'm pretty sure I can get what I need by adding a new column and combine the two at run time, but it's obviously not as clean. Related, is there any cost to just specifying the limit to the physical max for this new column? I'd like to avoid coming back to this issue in the future if it's decided that the new limit isn't large enough again. Certainly I would not get any safety checks if I unintentionally try to store a value that exceeds my intended max, but it's fine for me to take that risk on myself.