http://henkvandervalk.com a weblog about IT optimization Thu, 26 Aug 2010 11:23:53 +0000 en hourly 1 http://wordpress.org/?v=3.0.1 http://feedproxy.google.com/~r/HenksTechBlog/~3/En6ixxWfa10/sql2008-r2-dce-on-a-96-core-unisys-es7000-server-with-dsi-solid-state-storage-bulk-inserting-1-terabyte-within-10-minutes http://henkvandervalk.com/sql2008-r2-dce-on-a-96-core-unisys-es7000-server-with-dsi-solid-state-storage-bulk-inserting-1-terabyte-within-10-minutes#comments Mon, 23 Aug 2010 20:10:50 +0000 Henk http://henkvandervalk.com/?p=617 Hopefully you have seen the high-speed data loading demo live over the last 1.5 years at some SQL Server conference? I remember demoing it the first time –live- with Thomas Kejser at the European SQLPass 2009 conference during the opening keynote to show the 64+ Core support in SQL2008 R2. But for those of you [...]<img src="http://feeds.feedburner.com/~r/HenksTechBlog/~4/En6ixxWfa10" height="1" width="1"/> http://henkvandervalk.com/sql2008-r2-dce-on-a-96-core-unisys-es7000-server-with-dsi-solid-state-storage-bulk-inserting-1-terabyte-within-10-minutes/feed 0 http://henkvandervalk.com/sql2008-r2-dce-on-a-96-core-unisys-es7000-server-with-dsi-solid-state-storage-bulk-inserting-1-terabyte-within-10-minutes http://feedproxy.google.com/~r/HenksTechBlog/~3/4bsBONRAJpg/how-to-speed-up-ssis-derived-columns-transformations http://henkvandervalk.com/how-to-speed-up-ssis-derived-columns-transformations#comments Fri, 20 Aug 2010 14:13:13 +0000 Henk http://henkvandervalk.com/?p=595 Sedat Yogurtcuoglu noticed that’s it’s possible to increase the throughput of a pipeline by splitting Synchronous Transformations into Multiple Tasks in the same synchronous execution tree; we ran a series of tests with various number of Derived Column tasks and found out that it’s possible to more than double the throughput. If you want to [...]<img src="http://feeds.feedburner.com/~r/HenksTechBlog/~4/4bsBONRAJpg" height="1" width="1"/> http://henkvandervalk.com/how-to-speed-up-ssis-derived-columns-transformations/feed 0 http://henkvandervalk.com/how-to-speed-up-ssis-derived-columns-transformations http://feedproxy.google.com/~r/HenksTechBlog/~3/F3mxq1m_Ft0/how-to-increase-the-sql-database-restore-speed-using-db-compression-and-solid-state-disks http://henkvandervalk.com/how-to-increase-the-sql-database-restore-speed-using-db-compression-and-solid-state-disks#comments Thu, 12 Aug 2010 13:50:22 +0000 Henk http://henkvandervalk.com/?p=568 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 [...]<img src="http://feeds.feedburner.com/~r/HenksTechBlog/~4/F3mxq1m_Ft0" height="1" width="1"/> http://henkvandervalk.com/how-to-increase-the-sql-database-restore-speed-using-db-compression-and-solid-state-disks/feed 4 http://henkvandervalk.com/how-to-increase-the-sql-database-restore-speed-using-db-compression-and-solid-state-disks