When upgrading to a higher version of SQL Server, or when migrating to Azure, there can be certain compatibility issues between versions of SQL Server that can throw a spanner in..
We recently had an SQL Server customer who reported intermittent poor performance with an SQL query, similar to the statement below. The SQL query referenced a view, and that view..