SQL Info
You can use sqlserver_instance_info.sql script or as an alternative a stored procedure cstore_GetSQLInfo for getting information on the current installation and configuration of your SQL Server Instance.
More precisely, this script provides the list of the known SQL Server versions that have bugfixes or improvements over your current version + lists currently enabled trace flags on the instance & session.
@showUnrecognizedTraceFlags bit = 1 Enables showing active trace flags, even if they are not columnstore indexes related.
@showUnrecognizedTraceFlags bit = 1 Enables identification of the currently used SQL Server Instance version, which will be provided in the first result set.
exec dbo.cstore_GetSQLInfo;
Will show information on all currently enabled trace flags, describing the currently recognised Columnstore-related ones and will provide information on missing improvements through not installed Cumulative Updates and Service Packs.
exec dbo.cstore_GetAlignment @showUnrecognizedTraceFlags = 0;
Will show information on currently enabled trace flags that are related to Columnstore Indexes and will provide information on missing improvements through not installed Cumulative Updates and Service Packs.