I downloaded the databases earlier this year via torrent and attached them to a local SQL Server instance. Some notes: - The files are big. The data files were

I downloaded the databases earlier this year via torrent and attached them to a local SQL Server instance. Some notes: - The files are big. The data files were 486 GB and the log file (I haven't tried shrinking it yet) is 1.4 TB - There were no foreign key relationships defined. Nor indexes on commonly queried columns. Easy enough to add them as you work on tuning it. - To be usable by humans you'll need to set up some full text indexes for searching - they use Elasticsearch. SQL Server's Full-Text catalog doesn't get you where you need. https://stackexchange.com/performance https://stackexchange.com/performance