SQL Server columnstore indexes are helpful when it comes to retrieving large volumes of data. However, there are instances where columns are added to the table after the columnstore index was created. This means the new columns are missing in the columnstore index. Also, there can be cases where new tables are added and a columnstore index was not created. In this tip we will look at how we can identify these cases and create scripts to create the index.
https://www.mssqltips.com/sqlservertip/5742/script-to-create-and-update-missing-sql-server-columnstore-indexes
Tuesday, October 30, 2018
Sunday, October 21, 2018
Free eBooks from Microsoft Press
Free Microsoft eBooks are available in PDF, EPUB and Mobi for Kindle formats.
Find more training eBooks & books at The Microsoft Press Store.Download from https://mva.microsoft.com/ebooks
Subscribe to:
Posts (Atom)