I went into the Debug->SQL query tab and found this error when I ran most of the queries in SQL Server Management Studio:
Hint 'noexpand' on object 'View_CMS_Tree_Joined' is invalid.
Here's an example of a query that gave that error:
DECLARE @NodeSiteID int = 3;
DECLARE @NodeGUID uniqueidentifier = '7eb5661d-816a-4d11-8001-0bf58c6a164d';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @CMS_C int = 1;
SELECT [NodeID], [NodeAliasPath], [DocumentUrlPath], [DocumentCulture]
FROM (
SELECT [NodeID], [NodeAliasPath], [DocumentUrlPath], [DocumentCulture], ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND [DocumentCulture] = @DocumentCulture
) AS SubData
WHERE [CMS_C] = @CMS_C
If this is the problem, I don't know where this query is being called from.