DATABASE ANIMATIONS: WHY BIG COLUMNS MAY NOT AFFECT LOGICAL READS

Summary from the TLDR Data newsletter

SQL Server wide rows mainly hurt scans and multi-row reads, while point lookups can still fit on one 8KB page.