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 |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2009-11-10 : 06:09:42
|
| Hi,Are there any commands/processes I can run to measure the size of individual rows in a table in terms of bytes?I'm trying to find out how many rows in a given table are nudging toward the maximum row size limit (8060 bytes IIRC) to find out whether or not we can risk adding more columns.Cheers,Matt |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-11-10 : 07:53:19
|
| I would think you would be more concerned about 1st, 2nd and 3rd normal form than with row size limit....http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
mattt
Posting Yak Master
194 Posts |
Posted - 2009-11-10 : 08:51:30
|
quote:
Originally posted by DonAtWork
I would think you would be more concerned about 1st, 2nd and 3rd normal form than with row size limit....
Well, quite possibly. But I could still do with having my original question answered. |
|
|
|
|
|
|
Measuring row size in bytes