title: Limiting character length in Sql Cell, significant difference to memory and performance?
body: <p>Instead of using NVarchChar (max) for my field I am limiting the lengths arbitrarily. WHen does limiting these fields really make a significant difference in terms of performance? Every 100? 200? 1000 characters?</p>