SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2016 Columnstore Indexes and SQL 2014 SSMS users


SQL 2016 Columnstore Indexes and SQL 2014 SSMS users

Author
Message
diana.bodell 56517
diana.bodell 56517
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 Visits: 26
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?
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)

Group: General Forum Members
Points: 401706 Visits: 43454
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?


First, I am concerned about users using SSMS as a normal tool for access databases.
Second, SSMS is now a separate download, and you and your users can download and install SSMS 17.4.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
diana.bodell 56517
diana.bodell 56517
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 Visits: 26

Lynn, thank you for your response. We are not using Access databases, we are using SQL databases. My users are very qualified T-SQL coders in this case. The organization does not allow individual users to download anything and it takes a while to get them to do it for us, so I go back to my original question, which is whether I can use SSMS for SQL version 2014 to write queries against a table with a columnstore index.

Please advise.


Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)

Group: General Forum Members
Points: 401706 Visits: 43454
I didn't say you were using Access. You can download and use SQL Server Management Studio v17.4 and use it to access your SQL Server 2016 database servers and databases. I am currently using it to access SQL Server 2012, SQL Server 2014, SQL Server 2016, and hopefully soon SQL Server 2017.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)

Group: General Forum Members
Points: 401706 Visits: 43454
If your company doesn't allow it, get the powers that can to obtain it for your users.

SQL Server Management Studio is a separate download and not included with SQL Server anymore.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)

Group: General Forum Members
Points: 401706 Visits: 43454
But I can see why you thought that, my mind was working faster than my fingers, access should have been accessing in my first response.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
diana.bodell 56517
diana.bodell 56517
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 Visits: 26
Thanks Lynn, clearly you are not willing or able to answer my question. I appreciate your suggestions.

You said "First, I am concerned about users using SSMS as a normal tool for access databases" . To me, this read as you are assuming we are using the tool for Access databases, not "to access databases". I did not ask you to judge what we are doing with our data. I just want a simple answer to a simple question. My environment is probably very different from yours in that our data warehouse is FOR people to self serve their data through queries and cubes and PowerBI. I make sure that anyone writing queries is trained on T-SQL. At any rate, whether or not we query the database with SSMS or not is not relevant to my question. I also told you we cannot download and install software on our own machines.

Hopefully someone will simply answer the question.
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)SSC Guru (401K reputation)

Group: General Forum Members
Points: 401706 Visits: 43454
diana.bodell 56517 - Wednesday, December 20, 2017 1:05 PM
Thanks Lynn, clearly you are not willing or able to answer my question. I appreciate your suggestions.

You said "First, I am concerned about users using SSMS as a normal tool for access databases" . To me, this read as you are assuming we are using the tool for Access databases, not "to access databases". I did not ask you to judge what we are doing with our data. I just want a simple answer to a simple question. My environment is probably very different from yours in that our data warehouse is FOR people to self serve their data through queries and cubes and PowerBI. I make sure that anyone writing queries is trained on T-SQL. At any rate, whether or not we query the database with SSMS or not is not relevant to my question. I also told you we cannot download and install software on our own machines.

Hopefully someone will simply answer the question.

First, it was a simple statement of opinion, and if it offended you, then you took it the wrong way. My definition of power users does not include developers writing code.
Second, you are right, I don't know if SSMS 2014 will work with column store indexes in SQL Server 2016. I was suggesting that instead of worrying about that, that you (or your company) should consider downloading the latest version of SSMS since it is now separate from the SQL Server product. As I stated, it has no problems (at least in my use case) accessing SQL Server 2012 and newer SQL Server instances.


Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
diana.bodell 56517
diana.bodell 56517
SSC-Enthusiastic
SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)SSC-Enthusiastic (182 reputation)

Group: General Forum Members
Points: 182 Visits: 26
Thank you Lynn. If I took it the wrong way, I apologize. It is often the case that people on forums like this immediately make judgments about the way things are being done before understanding the circumstances. I have a dba here who works for me who, when he got here, was appalled that we let ANYONE query our databases directly because he believed all data should be accessed through an application. That's not what BI or data warehousing is about and he now understands that. Our data warehouse is a service that my team provides to our organization and although we do limit access appropriately, we have super users who are not developers who "mine" the data or at least do some pretty advanced analytics using queries and PowerBI. I understand that many organizations do not have super users who are not developers who can query appropriately. Anyway, I hope you have a nice holiday!
Chris Harshman
Chris Harshman
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38040 Visits: 7168
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.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search