Are you seeing any evidence of contention (PAGELATCH waits in tempdb)? If not and it's just a space issue, you probably just want to increase the size of those 12...

1. Full Database Backups (SQL Server): "A full database backup backs up the whole database. This includes part of the transaction log so that the full database can be recovered...

Maybe there's also an lstEquipment procedure? Try it with the dbo schema -- i.e.,

dbo.lstEquipment

You should always preface/qualify object references w/ schemas.

I didn't because I didn't know the...

It could -- You tell us.

Execute the select in the query in the view without the WHERE clause. Does it return anything? If not, then there is no data, period.

If...

Your CTE does not tell the server to get only the row with the max pc_id. It tells the server to get the max pc_id for each combination of pcs.pc_desc,...

If we respond with the following is how you return the average # of days a physician had cases, is that useful to you?

Or this?

Doctor     ...

A link that further explains what, how, & why to provide DDL, sample data, & expected results for the sample data: How to post code problems

That worked. I don't know why I struggled so much getting that syntax right.

Thank you, Arthur!

Convert(101) makes NO sense when reviewing code for date formatting problems - unlike the format which is highly understandable (and maintainable).  We all agree performance is important, but not at...

Yes, that tool could help you find stored procedures that reference the table, as could Jeff's query, or right-clicking on the table in SSMS & selecting "View Dependencies"

But once you...

The WHERE clause has to precede the GROUP BY CLAUSE -- where filters data before it is aggregated

SELECT...
FROM...
JOIN...
WHERE...
GROUP BY...
HAVING...
ORDER BY...

Why not use STRING_SPLIT?

The spaces around the slash complicate it slightly since STRING_SPLIT accepts only a single-character delimiter, but as long as the spaces are consistent, you can handle that...

I suspect you meant "...relational databases are not going away."?

MySQL functions --

DATE_SUB(CURDATE(), INTERVAL 7 DAY)

-- won't be of much use on SQL Server 2019.

Not aware of any property that can be automatically read.

As an alternative, could you:

1. Rename table;
2. Create a view w/ the currently-used table name that excludes the deprecated columns; &

...