• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 938
  • Last Modified:

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

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.
2 Solutions
SQL Express has a hard limit of 4GB total capacity.
SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage.

Reference: http://www.microsoft.com/Sqlserver/2008/en/us/express.aspx
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?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

0nepieceAuthor Commented:
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?
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.
0nepieceAuthor Commented:

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now