Bill,

I think you did a great job (and thanks for the break for today).

This is one of those places where you can make a difference in an organization. It would...

Thanks for the note, and I'm sure everyone at Red Gate and in the community appreciate your thanks. We try to help.

Steve

Unrelated, like for another application? I wouldn't do it, but I think some people see SQL Server as a database and a single one at that. They don't get the...

Shouldn't, but it will wreck your indexes and create fragmentation. Why run it?

Once you start restoring, you're applying log records to the database. The log itself doesn't get restored, but I believe that it's marked as truncated to the restore time.

To get...

Patches are cumulative of other patches since the last service pack.

Which results?

The alias ones? Use

where [10%] > 1000

I'm not, but I was there last year and thought it was great.

364k records might be more than 10GB. Have you tried sp_psaceusde to see the size of the table?

Good to know!

I'd make it large and see.

Shrinking the database shouldn't matter, but it does mess up your indexes (fragmentation)

I'm trying to get them to. If I get the time, I might go spend some time with them and see what I can document.

There must be more to the error. Perhaps file permissions?

What's the problem?

Splitting the file must be done with some programmatic code (VBScript or VB or C#). You can commit the file in smaller batches (options in the transform data...

Most of our videos here are from Jumpstart, and I own part of the company.

Microsoft has a series of webcasts and screencasts as well on MSDN.