Don't see anything directly wrong the calcs, although you should not do a calc on every LogTime column in every row, you should compare LogTime directly to the 60-days-ago EPOCH...

A few quick thoughts (numbered to make discussion of them easier):

(1) You need to normalize this design, you're storing huge amounts of duplicate data.  Specifically, encode the database name with...

Several things that would/should help.  You can implement / not implement each one as you see fit:

1. How do you most often query the table?  By Ids or by datetime? ...

You're welcome.  Thanks for the confirmation!

Change the end of the statement from ," ","_") to:

," ","")

Also, considering that VALUES didn't actually come out until 2008, your lecture about getting rid of the old syntax "decades" ago is full of hooie.  As for someones data...

DROP TABLE #sampledata 
GO 

CREATE TABLE #sampledata
(
id int IDENTITY(1, 1) NOT NULL PRIMARY KEY, --<<--!!
folder  varchar(100) NULL,
folder2 varchar(100) NULL
)
GO 
INSERT INTO #sampledata VALUES
   ...

No, you should (almost) never need to restart...

Indirectly, yes there is, and it's a guaranteed locking approach, since it's provided by the db engine itself, and uses its own locking mechanisms internally.

Use system procs sys.sp_getapplock...

Indirectly, yes there is, and it's a guaranteed locking approach, since it's provided by the db engine itself, and uses its own locking mechanisms internally.

Use system procs sys.sp_getapplock and sys.sp_releaseapplock.

Before...

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

...

...