Script Download: CheckTF834CSI.ziphttp://gallery.technet.microsoft.com/How-to-detect-trace-flag-1ce1152a
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 http://aka.ms/onescriptingallery