DMV Column Output Definitions and Options
Hello, I am finding it impossible to find any documentation or help regarding column definitions and even column value options/definitions when running DMV functions. Just one example, I ran the select * from $SYSTEM.TMSCHEMA_ANNOTATIONS and it outputs this: It's hard to know what I am looking at and how to understand the output when I can't find any information on column definitions and even more important, the definitions of value options. Like with Name having different values like SummarizationSetBy, UnderlyingDateTimeDataType, PBI_FormatHint. I have no idea what those actually indicate. I mean I can make assumtions for some based on what they say but that doesn't really help. Or with SELECT * FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY What are the different options for OBJECT_TYPE and what do they mean. If anybody knows where I can find this information, specifically, it would be SO helpful. I have tried looking at the [MS-SSAS-T] and [MS-SSAS] and downloaded all 32 pdf's they have from the SQLServerProtocols.zip. But I have no idea how they can help with something like this.
