Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

VARCHAR(200) vs VARCHAR(2000) Expand / Collapse
Posted Tuesday, April 2, 2013 8:43 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
theashishtrivedi (4/2/2013)
If I define VARCHAR(8000) and store 10-20 characters in it, there should be some performance issue in long run (i.e. SQL Server will reserve the space for 8000 characters which is not utilized).

There's no space reservation. If you define a VARCHAR(8000) and store 20 charactersin it, it's the same in terms of storage as a VARCHAR(20) with 20 characters in it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437939
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse