>>
>>Einar,
>>
>>Try an image column instead.
>
>Hmmmmm I had to read up on it a little but it seems that it should work. Have you ever used an image column in this fashion before?
>In the past couple of days I have been pondering if I should redesign my table (41 1Kb binary rows instead of 41 1Kb binary columns) or if I should utalize the new feature of SQL2005 where row size limit can exceed 8Kb. Now rereading your post I have another scenario to ponder.
>
>I think redesigning (I am at a very early stage of table design so it doesn't matter if I have to redesign) will be the best option (most flexible and fastest). Any thoughts on this?
>
>Einar

Oh yeah. Re-design is the best approach. Image & text columns are a big performance drag. And having 41 similar columns - especially if any of them will be NULL for a time - is poor normalization.