I’m back again with one of my Bootcamp notes. This time a few points about optimizing for SQL Server.
There have been a lot of changes on SQL Server. It is no longer using cursors through OLE DB to connect, but MARS (Multiple Access Result Sets) through ADO.NET.