MMartin1 (11/4/2014)
Is this still an ongoing issue. I wouldn't mind DDL statements with some sample data if so. Are the columns in your where clause properly indexed and statistics current? Could total permitted = count(*) - total blocked? That may help as well. Are you getting the data across a network? If so SSIS is faster in these instances that a linked server connection and if you can build the transformation logic there as well. Otherwise trying to push 100 million records into ram is brutal.
Thanks for your reply but the case is closed as the task was completed differently.