As already mentioned, the less storage used, the less there is for a query to read, and the faster the query can perform. So variable length types are usually preferable in such cases when read performance is a priority.
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Updates perform faster on fixed length where as read performs faster on variable length due to data size.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/8593/