Category: SQL Server

Posts about Microsoft SQL Server, performance, features.

Extract Load Transform SQL Server

Could not create DTS.Application because of error 0x80040154

By Peter De Lange | by Peter De Lange

If you encounter the following error: Could not create DTS.Application because of error 0x80040154 From calling DTEXEC.exe. For instance like so: It could well be the case that the DTEXEC that is being called is not compatible with the database server you want to run the SSIS package on. Particularly your development environment may be susceptible to this problem. To solve this, search for all the different DTEXEC.exe versions on your machine and find the…

Continue reading

Extract Load Transform

How fast can SQL Server write to disk, and why am I not reaching those speeds? Speed test results

By Peter De Lange | by Peter De Lange

In my previous blog post I set up an experiment to figure out what is the fastest setup for SQL Server and SSIS to extract and load a file into a table. In this post I will be discussing the results of this experiment. The experiment The experiment considered a simple two step ELT process: The different variables that were tested: Total performance Taking the best performing scenario it looks like we can extract and…

Continue reading

Extract Load Transform

How fast can SQL Server write to disk, and why am I not reaching those speeds?

By Peter De Lange | by Peter De Lange

A question that regularly comes up in ETL scenarios is whether SQL Server can read and write faster if you divide your tables and indexes over multiple filegroups and your filegroups over multiple files. My standard thinking on this was always as follows: Depending on whether you can write those files to different disks or not this will be the case. In a single disk scenario it should not matter at all. I started out…

Continue reading