Maybe you didn't have any free space in your log file, so there was nothing to shrink. What value was in "Available Free Space" ??

When I find I need to...

We've got a few instances of large inserts occuring during production hours that cause blocking. I'm looking at breaking them up into smaller insert batches and/or dropping & recreating the...

Thanks for the reply. I should clarify that I'm not using a loop. It's just the 1 statement above. The 25,000 batch size is specified in the properties tab in...

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