I have a database on a SQL Server 2016 running in Compatibility Level 110. The problem is the query speed is awful!
The largest table holds about 70k rows of data, and when selecting the whole table in Management Studio it makes around 3 minutes to result everything. Interestingly, if I run the same query in dbForge Studio, the query returns in about 8 seconds.
Also if I run the query against the master database, and explicitly add the database name into the query, the query return quicker but in in about 30 seconds.
What is the difference between running a query in Management Studio, and dbForge Studio that makes then so different? Also why does the query result faster when run against another database (such as master). And finally, why does it take so long to return 70k rows of simple data?