Results 1 to 3 of 3

Thread: impact of default column size of 8000 at table creation

  1. 04-16-2003, 02:47 PM #1
    snooker00
    snooker00 is offline Registered User
    Join Date
    Apr 2003
    Location
    FL
    Posts
    5

    impact of default column size of 8000 at table creation

    What causes SQL Server 2000 to create tables with default column sizes of 8000 for a varchar datatype??

    I would assume this can cause significant performance problems.

    (see attached)
    Reply With Quote Reply With Quote
  2. 04-16-2003, 03:14 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Characteristics of varchar

    "Storage size is the actual length in bytes of the data entered"

    If you use 100 bytes in a varchar (8000)column , it uses 100 bytes.

    It wont be a problem in performance.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 04-16-2003, 04:04 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    I think default lenght for varchar is 50 bytes, but you can specify other value in your script.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules