O'Reilly logo
  • Dustin Waybright thinks this is interesting:

attributes that get updated frequently, where the update performance is a priority, you should consider fixed types.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


You can set the maximum character length in a non-fixed type, but SQL server chooses how much space to use based on the length of the value.