database size

Results 1 to 2 of 2

Thread: database size

  1. #1
    Join Date
    Dec 1969

    Default database size

    I am new to sql and am curious if it is normal for a database to in crease in size by 30% when importing to sql from access?<BR><BR>I am running sql 2000 server on windows 2000 the access tables I am using are from access97.

  2. #2
    Join Date
    Dec 1969

    Default RE: database size

    I could see a database being bigger if the incorrect datatypes were chosen. IE. Someone submitted to me a request one time to create a SQL table where every field was the TEXT data type. Major overkill. Also look at your numeric fields, as in my experience, TINYINT and SMALLINT often get overlooked.

Posting Permissions

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