Archive for the ‘Performance tip’ Category

How to increase the SQL Database Restore speed using DB compression and Solid State Disks (2010-8-12)

Category: Backup & Restore, Performance tip, Storage: SAN & SSD | 4 Comments

a couple of months ago I blogged about how to speed up a full database backup; but what about the restore speed? Indeed also an interesting topic to investigate. So I ran all kind of tests and found out that it is possible to restore a database at least 3 times faster provided that you […]

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

Category: Performance tip, SQL 2008 R2, SSIS | Tags: , , | 22 Comments

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 […]

« Older Entries
Newer Entries »
Better Tag Cloud