CODEWITHSUNDEEP
sql-serversizefield
Samir Adel
Samir Adel

Reputation: 2499

Increasing sql server varchar field size effect on application

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 ?!

Upvotes: 1

Views: 475

Answers (1)

Grant Fritchey
Grant Fritchey

Reputation: 2775

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.

Upvotes: 2

Related Questions