What is the maximum capacity of a SQL Server Express 2008 DB?

Posted on 2010-01-04
Last Modified: 2013-12-17
I'm creating an auto generated document code (procedure e.g. ITEM-000001) which is a nvarchar. Now I was hoping to know the limit of a SQL Server database so that I could determine the maximum amount of length of zeros for the document code that I'll be generating. Btw I'm making my application using C# .NET Windows Forms and MS SQL Server 2008 Express Edition. Thanks in advance.
Question by:0nepiece
    LVL 12

    Expert Comment

    SQL Express has a hard limit of 4GB total capacity.
    LVL 10

    Expert Comment

    SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage.

    LVL 10

    Expert Comment

    From reading your question, I guess you are looking for the length of an nvarchar column?
    You can define that when you design the table.

    If you want a fixed length for the values in that column, you can use a char (or nchar) datatype for better performance.

    Also with SQL Server it is possible to automatically generate unique values for a column (numeric or GUID), which could be easier then generating unique values yourself.  It is not possible with string-datatypes.

    Or maybe I misunderstood the question?

    Author Comment

    Yes I made use of a nvarchar column. Well how do I say this. So I have this ITEMCODE with nvarchar(30). 30 is just a number that came up in my mind. I have a format for the ITEMCODE that is ITEM-<zero count>+<record count> e.g. ITEM-00001. Now I was hoping to know the maximum possible of records I could store in the database for this so that I could make a reasonable estimate for the <zero count> length for my item code. Ehe, I'm still new to this so I'm experimenting and I'm not much sure of my idea as well. So 4GB is approximately how many records?
    LVL 10

    Assisted Solution

    Usually, the database limitations are not really an issue.  How many records do you expect to be added every hour or every day?  How many years of data do you need to support?  Then calculate how many records you need to support and adapt the length of the field to allow at least that.

    For example:
    25 years * 365 days/year * 24 hours/day = 219,000 hours
    If you have 1 record added every second during those 25 years, your will need
    219,000 * 3,600 = 788,400,000 records, so you need only 9 digits for your unique item number.
    LVL 5

    Accepted Solution


    Author Closing Comment


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now