The input & output I understand....

Have you determined you need an extra drive ? If the log file grew to 100 G, and other junk got placed on the drive, then cleaning up...

It ran for quite a while with no issues. Perhaps the "order by" in step 1 adds to the load on TEMPDB. I did find that TEMPDB is huge today,...

LutzM (8/26/2010)

---

Maybe it would help if you'd post table def and sample data in a ready to use format as well as expected result. Would save those volunteers around a...

I think that gives me the right dates, but is there a way to add more fields to the select ? Seems like I have to add them to...

What used up the space ?

If you restart SQL, you may free up some space from Tempdb that will at least let you function.

Why did you run out of space ? Are your log...

Could you use TRUNCATE-INSERT or replication to move the data without dropping the tables ?

Or you could probably use the results of sp_lock to choose the spids to kill.

Did you take a full backup before shutting down ? That's always a good idea to do before making changes to databases, servers, configuration etc ... Then you could...

After you write your script to send the email, write the detail to a table so you can review it later in case you miss it. I have a very...

Perhaps you could schedule a job to run every day, and when getdate = fiscalmonthstart + 1 you can start the job with sp_start_job.

Isn't that also a waste of resources to...

ejbatu1 (8/9/2010)

---

I had another question on this... is backing up the log file (overwrite mode) every two hours and backing up the DB once a day (at night) a good...

I'm a little late to this thread, but since this is live data, you should back up the table first so you can recover in case something goes wrong. If...

I think he's...