This is immensely helpful. Thanks a lot Craig. - Matt

Thanks very much Craig. Your knowledge is very impressive. - Matt

- The providers table has 60k records. Performance now is good, but I may increase the table size to...

Thanks Craig, that's helpful to know that the temp table may be saving me headaches.

Here are the structures/indexes:

[dbo].[Providers](

[ProviderID] [int] IDENTITY(1,1) NOT NULL, -- PK, Unique, indexed, non-clustered

[FirstName] [nvarchar](100) NULL,

[LastName]...

This is the ITVF:

[dbo].[fnDistanceITVF]

--===== Returns distance when passed two points, latitude and longitude

-- Converted to a high performance iTVF by Jeff Moden - 24 Jun...

Thanks a lot!

Thank you!

Well, after a crash course in log files, thanks to everyone here, here's what I believe I have to do:

My hosting company limits my combined db + log size to...

One followup. (Hope I'm not annoying everybody):

With the Simple recovery model I'm using, would BEGIN TRANS and COMMIT statements help free up space in the log when used as follows:

instead...

Looks like limiting the transaction log size to 30mb is not the answer:

Message = "The transaction log for database 'Customers' is full. To find out why space in the log...

dupe post

Thank you all for your valuable help.

The hosting company has done this (hope it's ok):

They said they do nightly backups. They set my recovery mode to Simple and restricted the...

Thanks Jason - why won't Shrinkfile help? How often is "regular" transaction log backups?

Thanks for the replies. As far as regular log backups, restore points, etc... It is a shared hosting DB ($10/month), pretty much locked down. I don't have rights...

Thank you very much!

Well, this has opened up a can of worms. With my old method of just adding a column to the Customers table, I would just add a property to my...