https://docs.microsoft.com/en-us/ef/core/modeling/entity-properties

Reading through that it sounds to me like EF doesn't support excluding columns when reading the database side of things BUT quick googles indicate that you can exclude a column...

I expect that is possible, but it would be messy to do and error prone and I expect difficult to maintain.

When doing changes like this, my preference is to make...

My guess with this is not a problem with the stored procedure naming but more with your permissions.

I just executed the following against a SQL Server 2016 instance and it...

This is a double post.  Did none of the answers in the previous thread help?

The query is identical...

Link:

https://www.sqlservercentral.com/forums/topic/need-help-with-sql-code

I think the first step to troubleshooting this is knowing what error you get.  Is it that it doesn't like your username/password or is it a TCP/IP error or a...

I am guessing you mean a SQL Server service pack update, right?

If so, have you tried going to the folder it extracted the data to and looking for a "setup.exe"...

A test environment is good for this and for other things too.

If you want to deploy a report for an end user to test (for example), this works great! Or...

As to what is in the logs, that I am not sure.  I don't know what specific error messages will pop up, but the log will tell you exactly what...

Doing a quick google on error ORA-00933 - it sounds like that shouldn't be thrown with a SELECT statement.  Is there more to the query that you did not include...

If the app is changing data and is doing it in a transaction, it could be they forgot to put a COMMIT in there.  Unlikely, but possible.

The other thing that...

From looking at it, it looks like the columnstore index is giving a bad estimate and that is causing it to use the clustered columnstore index as the estimates make...

It depends.  If the application has a timeout on the SQL connection configured, then the connection will go away when it is closed or timed out.  If the application has...

I am fairly certain those are showing the current connections to SQL Server.  You can connect to SQL Server and leave your connection idle for days and it is still...

As far as I know, SQL Server does not keep historical connection information.  You can see current information and it wouldn't be impossible to build up a snapshot system where...

First thing I notice is that your statistics look to be out of date with the cci plan.

Second, could you provide an actual execution plan for the rid method?   that...