Queries run slow after updating database from SQL 2008 r2 to 2014

0

I've changed my database edition from 2008 r2 SQL server express to 2014 enterprise edition. The point is, queries run like 3 times slower than the old server. I'm testing on the same data and I've already tried the following: SQL Server 2014 upgraded - queries very slow

Nothing have changed even after changing the compatibility level. Any ideas?

charles

Posted 2019-05-16T17:25:33.373

Reputation: 1

Answers

0

I've solved my issue by installing an older version of visual studio. I downgraded from 2017 to vs 2015 and it worked like a charm

charles

Posted 2019-05-16T17:25:33.373

Reputation: 1