Home Dashboard Directory Help
Search

Documentation of SQL-Server Express database size limit is worng by quandary1


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 872554
Opened: 5/13/2014 5:19:37 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

As written on
http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

and recited countless times all over the web,
and probably you'd find it on a few pages on MSDN,
the new limit of SQL-Server express is 10 GB, up from 4 GB in the old version.

However, the actual limit is neither 10GB nor 10GiB, it's actually 10'240MB (10 * 1'024 MB).
This is neither 10 GB (10 * 10E9 Bytes) nor is it 10GiB (10'737'418'240 Bytes).

It's only 95% of what I would have interpreted as being 10GiB (10'240'000'000*100/10'737'418'240 Bytes).

This is definitely a bug in the documentation, and may also be considered fraudulent advertising.
Details
Sign in to post a comment.
Sign in to post a workaround.