October 23, 2017 at 9:53 am
Did you try it? And what results did it produce? Notice that you are using INNER JOIN between your CSI cte and your NCI cte, so a given table would have to have both to appear in the results. What have you learned so far?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 23, 2017 at 10:24 am
ramrajan - Monday, October 23, 2017 9:31 AMCan you also post the query fo rrequirement 2
Identify all the tables which contain both columnsstoreindex and non-clustered index.
I could, but I won't. You have been given enough information to start experimenting on your own to figure out what you need.
I'd like to see you explain how the code I did provide you works. If you can't do that, don't use it. You will have to support it if changes are requested.
October 23, 2017 at 10:38 am
Here is what I will tell you. You have a query to identify all the columnstore indexes. Now you need a query to identify all the non-clustered indexes. Then you need a query to select all the tables where each table has both types of indexes.
Oh, you also have code that shows how to pull some of that together.
If you haven't solved this by tomorrow, maybe I will post what I wrote.
October 24, 2017 at 10:13 am
So, what have you accomplished?
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply