Doesn't require any VB/C# knowledge at all, just a small amount of T-SQL to maintain a table of file names. a For Each Loop Container is as good a way...

Sure, easy enough.

As you're looping through the files, make the first step in the container an execute SQL task that passes the filename to a stored procedure and outputs...

This should be what you're after:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en#AdditionalInfo

On the original question, I suspect with most work profiles, you'd get better overall system performance from putting TempDB on physical disk and allocating the RAM you were going to...

The OLE DB destinations for non-SQL databases are pretty slow generally and isn't due to the returning of rowid. It's inserting and committing every row one by one which is...

No. Only a single instance can listen on a given port. Why do you ask the question?

There will always be an overhead of some kind. How much depends on the setup of the VM infrastructure and whether it's running on virtualisation-aware hardware or not.

There are some...

I believe it's to do with ownership chaining - there was a similar thread here:

http://www.sqlservercentral.com/Forums/Topic694107-146-1.aspx#bm694237

Are you executing ad-hoc SQL or executing a stored procedure that they have EXECUTE permission on?

Because you can change it manually...

Anything that can ever return a different value without you providing a different set of parameters is non-deterministic by definition.

Is "column" the only dimension of the partitioning function? Could you post full DDL for the table along with all indexes, partitioning function and scheme?

Also the actual execution plan for...

Who knows whether they will or not. I can say that the 2008 R2 release was quite tactical in order to get some more traction in Business Intelligence rather than...

Well, Web Edition narrows your choices so it's not as big an answer as it may have been as any solution involving Replication or Mirroring is out.

The clear solution that...

Excellent - I'll have a watch of the video's Gail posted myself. To be honest, SQL Server Memory Management seems to be quite sparsely documented and lots of articles were...

The reason it's slow is that it's literally moving from the end of the file and stuffing data into the earliest gap that it finds, regardless of trying to preserve...