We have SQL Express 2005 and I realized our data file is almost reaching the limit (4GB).
Now my question is, how can I shrink the size of the file in order to prolong the need to upgrade (FE/BE)?
Also I see one table that has about 200 MB used for data and 450 MB for indexes, is that acceptable?
How can I see what indexes are not being used so frequent and can be dropped (for a particular table or in general)?
PS. Our front end app is an Access ADP and then therefore I don't see how the database can be split.
Thanks in advance.
Microsoft SQL Server 2005DatabasesMicrosoft SQL ServerMicrosoft AccessMongoDB