Archive for the ‘SQL 2008 R2’ Category

Reading as fast as possible from a table with SSIS (Part II) (2010-5-13)

Recently I blogged on how to be as selective as possible while reading from and OLE DB Data Source (Part I) and how to load the data from a single flat file as fast as possible into a SQL Server table. But you probably noticed that “Out of the box” SSIS reads data faster from […]

SQL under the hood (Part 1): Monitoring Current- & Pending Disk IOs (2010-3-10)

Do you know how many disk IO’s are being processed by your SQL Servers at this very moment? And how many of them are pending, waiting to be serviced? Which databases are the top IO consumers and which queries are actually creating the majority of the IO load? In this blog I will focus on […]