Do indexes count towards the 10gb database size limit on SQL Server Express?

Question

I'm working on a project that uses a SQL Server Express database that is decently large already and I know indexing specific columns / tables can take up quite a bit of space.

What I don't know is whether the space used by the index counts against the total size limit of the database. If anyone has any insight let me know.

Periphrastic

For a 10 gb database are you sure sql-express is the right tool to use? – Ithaca

Yes, the indexes count. In fact everything actually stored in the database .MDF files count. – Embosser

@BenjaminGruenbaum what do you recommend instead? I don't have time to refactor the service that runs off the DB to work with a different database engine. A full license for MS SQL is probably outside of the budget for the project so that's also not likely to fly. – Periphrastic

You can buy SqlServer 2008, you don't have to buy the newest version. – Ithaca

Answer 1

relational data counts towards the limit. This actually includes indexes, but not FILESTREAM data.

The full list of limitations can be found on MSDN. This includes the note on relational data.

Immovable

Indexes do not use FILESTREAM columns. Nor does the site you link to say anything like that. Indexes on relational data definitely count as relational data themselves. – Embosser

Apologies, Full-Text indexing uses FILESTREAM. – Immovable

Answer 2

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

What is excluded is the data stored in FILESTREAM data type, mentioned by Steve, since FILESTREAM data is stored in separate files, and not in MDF file.

Palinode

Answer 3

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

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

Begat