July 2006 Blog Posts
I came across this "little" tool today via Mike Gunderloy's The Daily Grind.
Tried it out. LOVE IT.
In this thread it's shown how to export query results to excel File using OpenRowset. The problem with this is that you have to create an excel file with columns. For me that is simply unacceptable because i had to export any query result to excel and having to make an excel file for each query is simply ridicolous. So I went looking into BCP. Now BCP can't export column names adn i saw some solutions that use a view but nothing really dynamic. So i had to do a little workaround.
It resulted in this stored procedure. Data is...
Well i've done some more testing of bulk import methods i described in my previous post. The difference between previsous tests and these tests are these:
1. Database recovery model was set to Bulk logged. (This improved performance by 2-3 seconds for each method)
2. I tried BULK INSERT and BCP with and without TABLOCK option.
3. I also measured general processor utilization and RAM. IO reads and writes were similar in all methods.
everything else was the same.
In a previous post I explained where an SSIS FastParse option can be found
when importing data from Flat files.
I finally had some time to explore all four of SQL Server 2005 Bulk import utilities.
2. Bulk Insert
3. OpenRowset with BULK option
4. SQL Server Integration Services - SSIS
I ran each bulk import option 12 times, disregarded best and worst time and averaged the remaining ten times.
I've come across Tod Hiliton's blog via Jason Haley's Interesting finds and there i found this great little add-in for VS2005.
The add-in was created by J.T.Leigh, i've installed it and I must say it works beutifully. I'm already using it.
It's a must have for blog posts containing code.
More info and CSAH download here.
I came accross this site and i must admit i've become an instant fan :))
It's Roller has the most amazing collection of sql blogs i've found so far.
It's created by Peter DeBetta and Adam Machanic as far as i can tell.
More good stuff at SqlBlog.com
In my previous post i showed how a generic comparer class in .net C# 2.0 can be made with the use of reflection.
This is the version 2. Faster, preetier, better. :))
It uses IL code generation in runtime with the use of a new .Net 2.0 class DynamicMethod.