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
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.
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, 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
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.