Learning Database Design and Data Types

Posted on 2012-09-11
Last Modified: 2012-09-29
I'm learning about database design and have the following question.

If you choose a data type that works but is far larger of a data type then what is actually, will the poor selection of data type negativily  impact the performace of a data base and cause higher memory usage since data types and there values are stored in memory?
Question by:compdigit44
    LVL 3

    Accepted Solution


    It's best to choose the most appropriate datatype for your data (obviously), but in the real world, it's often of vanishingly small difference if you don't. On a modern computer, I suspect you'd need to work hard to see a differences between using an INT and a BOOL, even though one is 32 times the size of the other.

    The place where it will make slightly more difference, if in using fixed-length vs. variable-length datatypes. Since a table with all fixed-length fields has mathematically knowable row start positions (row X starts at X x row-length-in-bytes bytes from the beginning of the table), it is supposed to make row look ups faster. Again, with a modern system, do your benchmarking. Your gains may be negligible compared to the cost to your design.
    LVL 19

    Author Comment


    Is there software out there can will scan your DB servers do see if it meets best practices / normizaltion standards
    LVL 19

    Author Comment

    Does anyone have any additional thoughts on this.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Copy only dates 3 59
    SQL Select - AVG 3 36
    report c# 9 56
    Order by but want it in specific order 2 14
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now