Query cache size in SQL Server 2014
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.