2 votesBill shared this idea ·
By using the following trace flag, the problem went away for me.
DBCC TRACEON( 1254, -1)
Tip from https://www.brentozar.com/archive/2017/08/what-if-week-what-would-you-add/. See comment by Bobby Aug 22 2017
It's not just table variables. Just doing simple joins on bigint columns with in-memory tables can cause the problem.
Pleas see Kay’s comment below. Now that AS works on PQ, this of course becomes much easier. However still some work & testing to make each connector available, so likely will evaluate which are more suited to traditional BI and prioritize accordingly
Redshift is really important. We are doing a project for Trimble Software and we are blocked because of the lack of DirectQuery in the Tabular data model.
Please make sure you include schema compare and data compare. Data compare is helpful when migrating from SQL Server to SQL DW.