The backup is just that, a backup, the server does not need to be in any particular state to back it up and a backup does not damage the key....

Typically you would have a step collect the max dates from the tables being loaded and use those as inputs into the source in a data-flow.

CEWII

I seem to remember only that the limit is something like 64K times the packet size or like 256MB by default.

See http://msdn.microsoft.com/en-us/library/ms143432.aspx

I am unaware of anything different in...

Perhaps it just ignores the setting when all are disabled, I'm not sure..

CEWII

I find I can read your question 2 different ways.

The first is if I delete or truncate when do I get space back in the filesystem, the answer is that...

That depends, I stopped using named pipes as a default protocol nearly a decade ago because of problems connecting. So while it is enabled I never want to use...

Not sure what you are asking. Are you worried about memory or disk or what?

CEWII

As are triggers.

CEWII

Using something like WMIExplorer you could look at the Win32_Processor class and the number of instances there will be the number of processors, within that class you can see cores...

I wouldn't use linked servers at all, I would use SSIS to do the job. One of the problems with linked servers are an error on one tends to...

Locally you almost always connect via shared memory, the fact that you say you disabled that one too is interesting since it is only useful for local connections. One...

Then I would look at a place nearby to host my website.

CEWII

I would be hesitant to host those pieces cross country. I would expect there be fairly serious performance penalties. While I agree that hosting them on the same...

I'd probably go with a detach/re-attach, then you could specify all the file locations. Gail? Your thoughts?

CEWII

I don't know of a site. As far as ETL'ing of data I try to do everything I can in SSIS. As an example:

This pulls some WMI data...