I agree that, if your application needs to reference very large entity-attribute-value datasets, then it would perhaps be best to move those specific tables out of SQL Server and into a NoSQL alternative that is more specialized for that purpose. Not only are EAV tables difficult to index and query in an optimized way, they tend to fragment more than conventional transactional tables, and they require a great deal of time and I/O to load or merge in an RDMS.