Glad I could help.

If you want a full copy of Management Studio, get a copy of Dev Edition of either SQL 2005 or 2008. It's about $50 (US). ...

Glad we could help. You're welcome.

Excellent. Definitely making progress. That also got rid of one of the nested loops joins and replaced it with a hash match. On this amount of data,...

hayzer (4/29/2009)

---

GSquared (4/28/2009)

---

If you want to convert a string like that to a time, then I recommend this method:

declare @Time int;

select @Time = 123757;

select dateadd(second, @Time%100, dateadd(minute, @Time%10000/100, dateadd(hour, @Time/10000,...

Yeah, I've used the export...import method too. That works well in some situations. I've found it quite advantageous when the data has to move across a slow network....

Before I knew what I was doing, I had a database set up with autogrow at 10% and autoshrink was on too. After a year or so, the drive...

Personally, I don't think I've ever used SSIS to move data from one SQL database to another, on the same server. I use T-SQL scripts/procs for that. It's...

You must cut down the largest tree in the forest, with ... a herring!

There are a couple of conditions in the Join clause that look like they belong in the Where clause. The ones about provider type and address type.

Try moving those...

I don't watch TV, so I have absolutely no clue what you're...

Sorry, I'm so used to Management Studio that I sometimes forget to check which forum I'm in.

In Enterprise Manager, you'd go to Management, Jobs, right-click the failed job, "View Job...

Lynn Pettis (4/28/2009)

---

Bob Hovious (4/28/2009)

---

Somewhere that man is getting well...

If you can't make it an identity, then take a look at Row_Number().

The performance boost depends greatly on what you're doing.

The boost from moving away from OLE automation to using CLR is huge, if you do that.

The boost related to migrating adjacency...

Read the article on Simple-Talk. It's not horribly complex, but it's not "only a child can do it"-simple, either. See if it makes sense to you.

It can be...