开发者

Increasing sql server varchar field size effect on application

开发者 https://www.devze.com 2023-03-12 22:15 出处:网络
What is the effect of increasing the size of a varchar field from 50 to 60 on a sql server database taking into consideration that i am working on a legacy application working with .net framework 开发

What is the effect of increasing the size of a varchar field from 50 to 60 on a sql server database taking into consideration that i am working on a legacy application working with .net framework 开发者_运维知识库1.1 ?!


50 to 60 is pretty trivial. If there's an index on the column you'll see slightly more pages in the index as you add larger sized data to the column since fewer values will fit on a single page. Other than that, I don't see much of an impact just referring to the size. You will have query and code that you'll have to take into account as well. You might also have a constraint that you have to be concerned with. That's about all I can think of.

0

精彩评论

暂无评论...
验证码 换一张
取 消