The question ask for the amount of free space, correct? ... Really didn't think any of the answers were complete since ... you needed to use the size from...

SELECT count(c.people_id) AS 'Inactives' --<<-- note counting from *right* table
FROM [BCC_DB].[dbo].[People] p
LEFT OUTER JOIN --<<-- note *LEFT* join
[BCC_DB].[dbo].[certs] c 
ON p.peopleId = c.peopleId
WHERE p.status = 1 
AND...

Presumably you want the driving distance and not the "as the crow files" (straight linear) distance.  For that you will need a software package.  You will also need to get...

...

...

The codes look ok.  Something else must be causing your issue.

You can use a query to see which table the view is currently pointing at:

SELECT referenced_schema_name, referenced_entity_name

FROM sys.sql_expression_dependencies

WHERE referencing_id = OBJECT_ID('dbo.Clients')

Also, I'd suggest creating a log table in which you...

I don't think so, I think 0 should mean your query accessed no partitions.  If it had accessed all of them, the total number of partitions should be there.

Review the...

I would never combine these tables.

I'd be much more concerned with determining the best clustered keys for each table.  Or whether, perhaps, they would best be heaps (individual rows are...

Can you post directly usable data, i.e., CREATE TABLE and INSERT statements.

I don't think so. ...

I don't think so.  Where did...

CREATE TABLE #table_1 (
    last_updated date NOT NULL,
    type_desc varchar(30) NULL,
    size_bytes bigint NULL,
    used_bytes...

Other than some advanced troubleshooting cases like Jonathan says, there is no reason you should use NOLOCK in your code.

NOLOCK probably does not do what you think it does. ...

All indexes are tuned to their best (for the current statement)

I'd rather see the actual indexes and the actual query plan for myself.

For example, how many rows are in #GRatings...