DMA Shows like "Unqualified Join(s) detected"

amachanic / sp_whoisactive

sp_whoisactive

GNU General Public License v3.0

1.17k stars 289 forks source link

DMA Shows like "Unqualified Join(s) detected" #34

Closed sandeshjonnala closed 3 years ago

sandeshjonnala commented 3 years ago

Team,

I am had Who Is Active of Version v11.17 (2016-10-18) and while i tried to plan for Migration and went with DMA got the error as Unqualified Join(s) detected.

Impact shown as Starting with database compatibility level 90 and higher, in rare occasions, the 'unqualified join' syntax can cause 'missing join predicate' warnings, leading to long running queries.

What could be the solution for this ?

amachanic commented 3 years ago

This was fixed quite some time ago. Can you update to a more recent version?

sandeshjonnala commented 3 years ago

This was fixed quite some time ago. Can you update to a more recent version?

Thank you for the response @amachanic