Create an ADO.NET connection manager that uses the Microsoft ACE OLE DB Provider to connect to an Excel workbook. On the All page of the Connection Manager dialog box, make sure that you enter the ...

High CPU or memory grants when using optimized nested loop or batch sort Provides a resolution for high CPU and memory usage when you run queries with optimized nested loop or batch sort operators.