How is the data coming in? Is this loaded through SSIS/bcp or is it in another table?

I would use Greg's statement to build the SQL I needed and then use...

Database Mail isn't a mail server. It has to route through Exchange or some other mail server to get to your inbox. The data is only stored in msdb long...

Best of luck there. 30 seems high, but it really depends on your SAN, the spindles, fiber speeds, etc.

For SQL Server, for your mdf/ldf disks, free space on the disk drive has nothing to do with the performance of the disks. Why would it? There's no swapping out...

There are lots of scripts on the site here. You might try searching for "restore log"

Here's one: http://www.sqlservercentral.com/scripts/T-Log/69750/

The state and message are just standard SQL completion codes. Nothing special there.

I suspect the logic in your job step isn't correct for subsequent runs.

The amount of space in the MDF file has zero to do with the performance of the disks. If you have high I/O, then you either don't have enough spindles,...

What command did you run? I don't like shrinkdb because you can't control it well. I prefer shrinkfile if I need to get back space and clear things up.

However, do...

You cannot backup and restore partitions. You can do filegroups, and if that contains just your partition, I believe you can restore that filegroup, then switch in the partition.

The other...

Excellent, and I'll try to edit it in a timely manner :hehe:

The logging can be just inserting rows in a table somewhere. Something easy in your control flow that just adds a step before/after each loop through a file.

It might help in upgrades, but I don't think the risk of the feature being used elsewhere is worth implementing it.

drowlfs (3/10/2011)

---

I kind of agree with that in production. But problems happen on production where a DBA (or developer who is doing the DBA work) needs to take a look,...

TravisDBA (3/10/2011)

---

Although I agree with the general direction of the ediitorial, database server security concerns all depend on the IT manager's policy on security. I once worked with a company...

Seems like overall news has been quiet. Rockies seem to be having a quiet camp.

The old men had practice last weekend, and that was good. Swung a bat for the...