Posts Tagged ‘Table Scan’

Speeding up Reading from a SQL OLE DB or ADO.Net Data Source (2010-1-20)

With small datasets on a test system you will probably hardly notice the difference, but when you are building SSIS packages that need to process Gigabytes of data in a production environment on a day to day basis, the following Performance tip to optimize reading from the SQL data source is one to remember.  1) […]

Optimizing SQL In Memory Table Scan processing speed (2010-1-9)

How fast can you can actually read data from a table that is already loaded in memory?  People often assume that, once it’s in memory, it’s as fast as it can get and won’t get any faster ? But how fast is it really ?  Let’s find out! The Math Method If the total table […]