BTW, I did receive an apology from the President of the company today.

That was nice, although someone posted a rude comment in his guest book. Please refrain from doing something...

It makes administration harder. I've only used it when I had data for archiving I could separate out into it's own filegroup. Or when I had disk constraints.

How much is...

This is normal. SQL Server will allocate some at boot and begin to request more from the OS as it feels it needs it. 1GB is pretty low and I'd...

The tasks run in parallel if they have no dependencies between them. You can add 4 connections with 2 data transform tasks, but no links between them and the 2...

You can set an alert to get successful logins, but I've had trouble getting it to work. Maybe BKelley will chime in.

If you have the logs, then you can save...

The Configuration Manager or the Properties of the server in SSMS should help you here.

Thanks for the notes and support, but I tend to agree with Bob McEuen. After I sent it, I felt bad about that last line. Actually would have preferred to...

I used to build a separate table for accounting periods. We always had weird ones that would sometimes end a day early or late. So I build a table that...

The woodstove is interesting and we've considered that. Get two benefits for the price of one. A wood fire and heat.

The alternative power is interesting to me because I know...

You can use DATEPART to find out which day of the week it is. Then depending on what you have DATEFIRST set to, you can add or subtract days.

For me,...

As Sameer mentioned (beat me to it )

Open the files in Profiler and you can replay them against another server or look through them....

Data loads as well. Is something happeneing on Fri night like this? Or maintenance as Bill suggested?

You can setup a trace, but you'd have to capture all T-SQL or stored proc executions on the server and dig through them.

Robert, I'll send a private message.

I think this will work and not a big deal since you are all on a single RAID 5 partition.

Might see some perfromance issues if the partitions are separated.

I guess...