This T-SQL script will demo how to detect if trace flag 834 is enable and column store indexes are used in SQL Server.
If trace flag 834 is enabled and column store indexes are used, you may encounter performance issues with applications. This script will demo how to detect this problem. If it exists, the script will warn you.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery