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 Qp.[CryptoVolume] BETWEEN 400000000 AND 500000000