If all you're going to do is store Lat/Long pairs, and you're NEVER going to do any spatial calculations in SQL Server (going to let client or other service handle...

Oh, right, sorry. Yes, I do see that more subtle highlighting on the first cell.

If you don't want that, then O don't know any way short of exporting to Excel...

What version of SSMS? I'm using 18.12.1, and it doesn't select any cell by default -- I have to have clicked on it first.

This question appears to be a continuation/extension of this one.

To clarify, we are talking about running out of file space for the log files (ldf) and not the backups, correct? If so, then more frequent log backups could help...

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...