Columnstore Indexes Scripts Library
Clone or download
NikoNeugebauer Merge pull request #25 from JocaPC/master
Added support for Managed Instance
Latest commit d993f56 Jul 23, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github
Azure Fixed engine edition in few additional files Jul 20, 2018
SQL DW 1.5.0 Azure SQL DW Updates Sep 3, 2017
SQL vNext 1.6.0 Suggested Tables Bug-Fixes Jan 15, 2018
SQL-2012 1.6.0 Suggested Tables Bug-Fixes Jan 15, 2018
SQL-2014 1.6.0 Suggested Tables Bug-Fixes Jan 15, 2018
SQL-2016
SQL-2017 1.6.0 Suggested Tables Bug-Fixes Jan 15, 2018
Stored Procedures Estimate Columnstore Compression Savings Jun 24, 2018
Tests 1.5.0 Install-All Updates Sep 3, 2017
.gitignore Git Ignore for 1.5.0 Aug 15, 2017
CONTRIBUTING.md
IndexTypeSelector.sql Reset the Online Rebuild Variable Jun 21, 2018
LICENSE Changed from GPL 3.0 to Apache 2.0 Aug 31, 2015
NOTICE.txt
README.md Update README.md Jun 26, 2018
cisl.psd1 1.5.0 Powershell Header Updates Aug 15, 2017
cisl.psm1
install_CISL.ps1 1.5.0 Install-All Updates Sep 3, 2017
remove_CISL.ps1 1.5.0 Powershell Header Updates Aug 15, 2017
setup_all.ps1 1.5.0 Powershell Versioning Updates Sep 3, 2017
setup_dac.ps1 1.5.0 Powershell Versioning Updates Sep 3, 2017
update-cisl.ps1 1.5.0 Powershell Header Updates Aug 15, 2017

README.md

Columnstore Indexes Scripts Library (CISL)

licence badge stars badge forks badge issues badge

Welcome to CISL - Microsoft SQL Server Columnstore Indexes Scripts Library

A columnstore index is a technology for storing, retrieving and managing data by using a columnar data format, called a columnstore. More information you can find here: https://msdn.microsoft.com/en-us/library/gg492088.aspx

The library is launched with the very first release on 1st of September 2015. The current release (1.4.1) is supporting SQL Server 2012, 2014, 2016, 2017 & Azure SQL Database.

At the moment, the CISL consists from 8 scripts and 9 stored procedures (8 standrad & a 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:

  1. 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.

  2. Suggested Tables (suggested_tables.sql) - Lists tables which potentially can be interesting for implementing Columnstore Indexes.

  3. Row Groups (row_groups.sql) - Shows detailed information on the Columnstore Row Groups.

  4. Segment Alignment (alignment.sql) - Shows the alignment (ordering) between the different Columnstore Segments.

  5. Fragmentation (fragmentation.sql) - Shows the different types of Columnstore Indexes Fragmentation. (Note: SQL Server 2012 version does not exist, since Nonclustered Columnstore Indexes in SQL Server 2012 are non-updatable and hence have no fragmentation)

  6. Dictionaries (dictionaries.sql) - Shows detailed information about the Columnstore Dictionaries.

  7. Memory (memory.sql) - Shows the content of the Columnstore Object Pool.

  8. Row Groups Details (row_groups_details.sql) - Shows detailed information on the Columnstore Row Groups, listing all individual row groups and filtering them based on different criterias.

License

Apache License 2.0