You can add a columnstore index to a table with a rowstore index. It's just another index.

I've had to do this in the past for an app. Here's what I did:

• find out the data being written. dup this table structure in a small admin db...

I think the key words there are performance. If we've improved performance with an OVER(), then yes, we ought to refactor older code. If we've changed from an IF statement...

I get less concerned over the formatting of code. These days we have products like SQL Prompt and other tools that can reformat things as we need them. I do...

Indeed. Part of what I wanted to convey is that you need to look at the problem and decide if it's a nail or screw.

I think most people get using...

LA

This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show.  There might be some overlap...

I prefer to use Powershell, and Invoke-DbaQuery from within my Powershell scripts for things that require T-SQL. The source of all scripts is then in my Powershell library, instead...

Btreieve, wow, I remember that on Novell. Not a fan.

Great advice. Similar to what I've heard from other sources

Glad you liked it. I thought it was a good post on a topic that many of us spend minimal time thinking about.

And as you can see, I replied under the test account, which I logged into with an email that is different from the user name

FWIW, I wouldn't ever install SSMS 2014 or anything below the current SSMS v18, which works with all instances of SQL Server.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Be good to post the link you got for others.

What you are looking to do here is pivot the data. As noted above, we would prefer to see DDL that helps set up the problem. Use a small set...