Unable to process request. Error: The hint 'SNAPSHOT' is valid only with memory optimized tables. Command Text: SELECT [Count]=COUNT(1) FROM [Queryable].[Data] P WITH(NOLOCK) INNER JOIN Website.SecurityAccessProduct Qsap ON Qsap.[AccessId]=1 AND Qsap.[ProductId]=P.[ProductId] LEFT JOIN [Quote].[MemoryPriceLive] Qp WITH(SNAPSHOT) ON Qp.[DataId]=P.[DataId] LEFT JOIN [Queryable].[DataCrypto] Dc WITH(NOLOCK) ON Dc.[DataId]=P.[DataId] WHERE (P.[LCID]=1033 AND P.[Published]=1) AND P.[ProductCode]='crypto' AND CASE WHEN Qp.[Price1d] = 0 THEN NULL ELSE ( Qp.[Last] - Qp.[Price1d] ) / Qp.[Price1d] END BETWEEN 0.0075 AND 0.009