attributes that get updated frequently, where the update performance is a priority, you should consider fixed types.
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 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.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/8592/