Geek Answers Handbook

Indexes counted regarding 10 GB database size limit on SQL Server Express?

I am working on a project that uses the SQL Server Express database, which is pretty decent and I know that indexing certain columns / tables can take up quite a bit of space.

What I do not know is whether the space used by the index is equal to the overall database size limit. If anyone knows, let me know.

+6
source share
3 answers

relational data counted to the limit. This actually includes indexes, but not FILESTREAM data.

A complete list of restrictions can be found on MSDN . This includes a note on relational data.

+2
source

The limit is valid for the size of the MDF database file, so yes, it will include your indexes, as well as other database objects, such as SQLCLR code, etc. Starting with SQL Server 2008, full text indexes are also part of the database, so they will count on the limitation.

Data stored in the FILESTREAM data type mentioned by Steve is excluded because FILESTREAM data is stored in separate files, not in the MDF file.

+1
source

I wrote a detailed blogpost about the 10 GB size limit in SQL Express and how you can try to keep your database size below the limit. As others mentioned in the answers above, indexes add to the size of your database.

Take a look at my blog post and standard SQL Server reports (available from SQL Server Management Studio) to find the size of your indexes. They can be huge if you use many indexes.

+1
source

More articles:


All Articles