• You should probably demonstrate your database structure and the type of queries you are running.

    As a Data Warehouse company with a 3TB database, we installed SQL Server 2014 and configured our primary tables as Column Store Indexes and this was a HUGE performance boost for us. 30min queries will take 10secs for example.

    Column Store Indexes has a lot of limitations, but it works really well if you use it correctly.