• diana.bodell 56517 - Wednesday, December 20, 2017 11:43 AM

    There were significant changes in 2016 to SQL columnstore indexes. I'm anxious to start using them in my data warehouse but I'm concerned about whether my super users who don't have a 2016 version of SSMS will be able to query them. Can someone give me some insight here?

    the version of Management Studio does not have any effect on what commands you run in it, that is solely determined by the version on the server.  I've regularly run commands against a SQL Server 2014 or 2016 instance from a 2008 Management Studio without problem even though I'm using features not in 2008.  The only side effect is that intellisense obviously would not recognize any new commands, functions, or language constructs, but they will run on the server.