New answers tagged server
You can restore it if you're not using any EE features. In this case, you are using table partitioning so that restore path is not supported. You can run SELECT * FROM sys.dm_db_persisted_sku_features to check for other features that can block your cross-edition restore.
MyISAM or InnoDB? Depending on which, you need to see the appropriate cache buffer. If you had 16GB of RAM, you could set that so that the table will (eventually) be entirely in RAM. That would move it from being I/O bound (as it probably is now) to being CPU bound. At that point, an old, slow, cheap, spinning drive will be almost as good as SSDs. Can ...
Top 50 recent answers are included