Script Download: CheckTF834CSI.zip
http://gallery.technet.microsoft.com/How-to-detect-trace-flag-1ce1152a

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.

image image
 image

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery