Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aex
Yak Posting Veteran
60 Posts |
 Posted - 2006-07-02 : 21:11:01
|
| I am using sql server 2005. The max size per row in a table is about 8096 byte sth which I can't really remember. I want to know how can I handle this kind of problem?Thanks in advance for any reply.aex |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-02 : 21:36:16
|
| this is related to your table design, are you sure you need all those strings and with those size? you can try to divide the fields and see if you can normalize the table a bit--------------------keeping it simple... |
 |
|
|
aex
Yak Posting Veteran
60 Posts |
Posted - 2006-07-02 : 22:09:21
|
Actually I have already normalized the table. In fact, I can separate the table fields to another table so that to have one-to-many relationship. But I want to make my table much simple. So, if I can increase the row size for the table, I do not need to create more tables which will spend me more time in constructing inner join query.  aex |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
aex
Yak Posting Veteran
60 Posts |
Posted - 2006-07-02 : 23:08:07
|
So sad to know that I can't increase the row size.  I think I hv now choice then, that I hv to create more table.anyway, thanks for the useful tips for that.  aex |
|
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-07-03 : 05:53:36
|
| aex - Post the table structure you were trying to create - perhaps we can help you structure it better. Ryan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
aex
Yak Posting Veteran
60 Posts |
Posted - 2006-07-03 : 05:59:28
|
thanks thanks alot Ryan for willing to help. I really appreciate that and sorry for my late reply. In fact, I have already solved the problem by splitting the fields to number of tables. Now its almost late here and I gotta get back home.  Once again, thanks you.aex |
|
|
|
|
|
|
|
|
How to increase row size manually?