Yes, but we need more information.  Please Read'n'Heed the article at the second link in my signature line below for...

Hi,

thank you for this Informations!

At night, the flat files from around 500 customers arrive on an FTP - Step by Step. The SSIS job currently starts at 08:00 AM...

Heh... it's funny.  I was going to suggest the same things about the method I use.  I maintain the adjacency list (with a detector to prevent loops) and regen the...

I'm one of those folks that Phil is speaking of.  He's correct about BCP but BULK INSERT is the fastest and, done correctly, it's nasty fast.  A BCP format file...

hey,

hold on - wasn't this why hierarchyID types were invented ?

you can even use persisted computed columns to make it nice and fast.

you would need a 1 time hit...

Hi Experts,

Currently we are using SQL Server and Database Mail to send reports and with new projects and requirements it seems like the Report sending will increase . Is...

Awesome!!!

Very nice to understand.

But,I do not want to to hard code value 12 and 8. This is what i used that Reverse function.

(Sometime there is a chance in the...

Awesome post, Ronald. And thanks for including the methods of revelation and discovery.  Those help in effectively troubleshooting similar problems.

Has my customer conversion rate improved since this time last quarter?

What is my annual sales growth as compared to last year?

The answers to the questions can be found by...

Shifting gears to the subject matter... I don't see how anything led to answering the two questions posed at the beginning of the article, which were...

It can be used to...

The problem with links on other sites is that other sites have been known to go away.  Could you attach the .ZIP file to this site please?

Simple and to the point.  I would put a comment with it to explain what is being so that someone with less SQL...

 SELECT LEFT(RIGHT(@Text,12),8);

It still makes a difference even on something small when you're working with millions of rows.

You say the "standard job boards are not pulling the right people at all".  What kind of people are you getting that are disappointing you?

I can tell you that filling...