GilaMonster (11/4/2016)
Luis Cazares (11/4/2016)
It seems correct, the only issue would be with xml columns, but I'm sure those would be handled differently.Not a concern here, since XML columns, like the MAX datatypes can't be in the index key.
I mentioned it, because the query returns XML indexes. Which of course use xml columns.
As mentioned, it's not a concern. Especially when using the HAVING clause.