I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

July 2006 Blog Posts

Aptana - The Web IDE

I came across this "little" tool today via Mike Gunderloy's The Daily Grind.  Tried it out. LOVE IT.  My JavaScript development from now one is only in Aptana IDE. And the coolest first observation you see is an IE and/or Firefox icon near the Javascript function you want to use that tells you if it's compatible with the browser and DOM 1 and/or DOM 2. Homepage here.

posted @ Monday, July 31, 2006 4:57 PM | Feedback (3) | Filed Under [ Misc ]

Export Query results to Excel with Column names in T-SQL

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...

posted @ Tuesday, July 25, 2006 3:11 PM | Feedback (84) | Filed Under [ SQL Server ]

More on Flat File Bulk Import methods speed comparison in SQL Server 2005

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. Method ...

posted @ Saturday, July 22, 2006 3:05 PM | Feedback (12) | Filed Under [ SQL Server ]

Flat File Bulk Import methods speed comparison in SQL Server 2005

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. Those are: 1. BCP 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. Results are: 1. ...

posted @ Monday, July 17, 2006 5:32 PM | Feedback (11) | Filed Under [ SQL Server ]

Copy Source As Html (CSAH)

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.

posted @ Friday, July 14, 2006 3:04 PM | Feedback (1) | Filed Under [ Misc ]

SqlBlog.com

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

posted @ Wednesday, July 12, 2006 7:49 PM | Feedback (4) | Filed Under [ Misc ]

Sorter class v2 - A generic comparer/sorter class

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. More here.

posted @ Wednesday, July 05, 2006 5:21 PM | Feedback (2) | Filed Under [ .Net ]

Powered by:
Powered By Subtext Powered By ASP.NET