Hi Frederico, Thanks for the reply and sorry it's taken awhile to get back. .

where exactly is the contention happening?
And are server specs up to...

HI. I am also exploring partitioning of a large very active database. Basic question about file groups. Is there a best practice for their organization? For example I was thinking...

Thanks so much Barry. That logic basically works for me. It also answers a fundamental question I had. Do I have to write code to do this.. ie sum =...

yes very good that's it.

I am familiar with Server Broker to the extent that I have taken the virtual lab, researched the internet, and am now reading Pro...

I might mention that that will be done through SSIS. Another issue we're trying to mitigate is that all these files are hitting our server at about the same time...

The plan is to process the files into staging tables and then put a message in a queue announcing their arrival with a batch id.