First, having the data in a consumable format is something that will get you a LOT more replies.  The way you have it now, we have to do the leg-work...

My understanding of clustered columnstore indexes is that they are not ordered (except in Azure).  So, my opinion, your non-clustered indexes (the UNIQUE and the NONCLUSTERED are both NONCLUSTERED) may...

As far as I know, you can't change the color of SSMS based on who you connect as, but you can change the status bar color:

https://www.sqlshack.com/how-to-set-custom-colors-in-the-ssms-status-bar/

And, with a quick test...

Oh gotcha... Yep, that makes sense then.  You are more curious at the moment which queries may break by changing the index, not which indexes are in use and which...

Just putting my 2 cents in here but putting 300 GB of data on a 4 TB disk sounds like overkill.  If possible, I'd put it on a SAN and...

I don't see anything obvious (although I am not an XML guru by any means).

Have you thought about looking at the indexes and the data SQL stores on them rather...

Since on dev it uses all 56 GB of memory, you would need more than 56 free on live.  How much exactly, I am not sure.  But you can get...

Just to confirm this, you have 1 billion rows in around 5 or 6 tables that are changing frequently where the column needs to be updated?

There are always tricks you...

What "DateDiff" are you trying to get?  The number of days, weeks, months, years, hours, seconds, etc?

I suppose the easiest way to help you would be if you could post...

I think the faster way to parse XML is to do it outside of SQL.  In general, SQL is not "fast" at parsing XML data.  I think your interpretation of:

Given...

One solution (not mine) was using the Box API:

https://community.box.com/t5/Platform-and-Development-Forum/Using-the-box-api-in-SSIS/td-p/68823

Thank link has the general process as well as some code to help with it.

I personally have not done this as I...

Thanks for the followup and solution!

That is weird about the syntax... I was using your original syntax when I tested it and it worked for me.  But maybe it was...

Maybe my eyes are playing tricks on me, but what is the difference between B and C?

It was a bit of a vague question.  Is the query only run...

I signed up!  I'm always curious about new DBA tools.  Survey was a bit vague with some things.  Like do you prefer the GUI or CLI.  Would you consider writing...