CSIL
Welcome to CISL - Columnstore Indexes Scripts Library
The library is launched with the very first release on 1st of September 2015. The first release is targeting SQL Server 2014 only, but in the following months I am expecting to launch SQL Server 2012 & SQL Server 2016 compatible version.
At the moment, the CISL consists from 7 scripts, but soon (in 2015) I expect to expand this library with more complex stuff such as maintenance solution.
Every CISL script comes in 2 variants: a simple executable script & stored procedure.
Stored Procedures are here so that you can store them inside your database and use more commonly and include them into your own solutions.
CISL consists from the following scripts:
- SQL Info (sqlserver_instance_info.sql) - Provides with 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.
- Suggested Tables (suggested_tables.sql) - Lists tables which potentially can be interesting for implementing Columnstore Indexes.
- Row Groups (row_groups.sql) - Shows detailed information on the Columnstore Row Groups.
- Segment Alignment (alignment.sql) - Shows the alignment (ordering) between the different Columnstore Segments.
- Fragmentation (fragmentation.sql) - Shows the different types of Columnstore Indexes Fragmentation.
- Dictionaries (dictionaries.sql) - Shows detailed information about the Columnstore Dictionaries.
- Memory (memory.sql) - Shows the content of the Columnstore Object Pool.