Query cache size in SQL Server 2014 Is there a way to define/set/increase the query cache size in SQL Server 2014 similar to what MySQL has

http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html
SQL Server doesn't have any direct analog of MySQL's query cache, i.e. an in-memory cache of actual query results. Data and compiled query plans will be cached in memory, however.

If you've got a particularly expensive query with a lot of joins, you may want to look into creating an indexed view.