General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>>
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only