New System Stored Procedures in SQL Server 2017

Got a few new stored procs for columnstore indexes:

  • sp_add_columnstore_column_dictionary – input params for @table_id, @column_id
  • sp_is_columnstore_column_dictionary_enabled – as above, plus output param for @is_enabled bit
  • sp_remove_columnstore_column_dictionary – input params for @table_id, @column_id

And a couple for snapshot views (which appear to be related to the new snapshot messages in sys.messages)

  • sp_refresh_single_snapshot_view – input param for @view_name nvarchar(261) (!), @rgCode int
  • sp_refresh_snapshot_views – input param for @rgCode int

To see the public portions of their source code, hit up master.sys.all_sql_modules. Documentation doesn’t appear to be live yet at docs.microsoft.com, nor in the Github repo.

Previous Post
New sys.messages Entries in SQL Server 2017
Next Post
No More SQL Server Service Packs: Is CU12 the New SP1?

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}