[Script of Mar. 6] How to detect trace flag 834 and column store indexes in SQL Server (T-SQL)
Script Download: CheckTF834CSI.zip
https://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.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery