Should all columns be under 8kb for page size

I currently have a table with 50 columns
It has 100 millions rows

I could reorganise these to approx 20 as not all the columns are used for each row
I would need to create a new table for the other data

Is it generally a good idea to try and get each row under 8kb?

I've been reading a lot into performance tuning and optimization recently so wondering if I need to get the foundation right
websssAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
What are you storing in a column with more than 8Kb size?

Splitting the columns in two tables where the second table has the less used columns is a very good idea and this technic is often used and it's called vertical partitioning.
1
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
>>Is it generally a good idea to try and get each row under 8kb?

Yes. It basically depends on the requirement. So if you have heavy column like varchar, varbinary...you cannot do anything,

FROM MS - > Surpassing the 8,060-byte row-size limit might affect performance because SQL Server still maintains a limit of 8 KB per page.

Read section ->  Row-Overflow Considerations

https://technet.microsoft.com/en-us/library/ms186981(v=sql.105).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.