The size of each table entry is a performance parameter. this means that if the record size was small, SQL Server retrieves more records in each read from the physical hard disk.
In most of our queries, we do not use the entire column of the table and can use some columns only in a specific query. Is it possible that we will split the columns of each table into better performance.
I am using SQL Server 2008 R2.
Thank.
source
share