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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-12-03 : 23:13:16
|
| I've got a table to record user feedbackCREATE TABLE MyTable (UserID INT ,Feedback VARCHAR(8000))Some of the feedback is paragraphs of text. Most of the feedback is a single word selected from a list ~ 8 characters long. I'd say the ratio is about 3 short for each long feedback.Given the disparity in feedback lengths, is this an inefficent use of the table space and should I use two tables? Or is SQL optimizing this well enough so it's not a problem ? |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-12-03 : 23:27:29
|
| Sam,Personally I wouldn't worry about it. SQL's pretty smart at that sort of thing. The only issue is when you try to estimate you disk requirements. Perhaps you could place it in its own filegroup if you feel that way inclined....DavidM"SQL-3 is an abomination.." |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-12-04 : 00:30:22
|
| I'd much rather not solve problems that don't exist !!Thanks for your thoughts. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-12-04 : 07:41:18
|
| A varchar(8000) typed column storing the word 'Samc' as a value will take up 6 bytes, I believe. 1 for each character and 2 for the length.Jay White{0} |
|
|
|
|
|
|
Column width considerations