Doing so will use an ODBC link to the newly upsized tables on SQL Server. The resulting arrangement is slower than the previous one. Upsize data to SQL Server by creating an entirely new database ...

WHILE loop performance in SQL Server 2008 Your ... a temporary copy of the data to be used by the cursor. All requests to the cursor are answered from this temporary table in tempdb; therefore ...