Gift Peddie (4/11/2009)

---

andrew gothard (4/11/2009)

---

but I don't foresee the day when "one language to rule them all" will ever come into being. quote]

Isn't that what ADA was supposed to...

Hi eudes - there are a number of 'issues' with SSIS performance, but the commonest one I've come across which may be an issue with your migration from DTS to...

but I don't foresee the day when "one language to rule them all" will ever come into being. quote]

Isn't that what ADA was supposed to be? :w00t:

Jeff Moden (4/9/2009)

Ummm... I'd be real careful about making that recommendation... First, despite the fact that the INT function is a bit faster, I actually agree with the others about...

Jeff Moden (4/4/2009)

---

And, you're absolutely correct... some simple additions such as TRUNC(Date) would make life a bit easier. On the other hand, I hope to never see DECODE in...

Bruce W Cassidy (4/8/2009)

---

[font="Verdana"]

A good article.

I've been using that trick of breaking large operations down into smaller ones since, oh, SQL Server 6.5 days?

Compared with re-assembling the small steps into...

Or "Bollocks" as we like to call it in th eUK. ...

GSquared (4/8/2009)

---

andrew gothard (4/8/2009)

---

Manie Verster (4/8/2009)

---

DBA's have the assumption that all developers are bad for a database or bad SQL programmers. Well, I am a develepor cum DBA but before...

GSquared (4/8/2009)

---

Robert Frasca (4/8/2009)

---

GSquared (4/8/2009)

---

On the "temp tables are bad" thing, the coding requirements for the place I work state that table variables should be used instead of temp tables,...

Manie Verster (4/8/2009)

---

DBA's have the assumption that all developers are bad for a database or bad SQL programmers. Well, I am a develepor cum DBA but before I had to...

bob.willsie (4/3/2009)

---

I think its important to have a good foundational understanding of programming and when/why to use an SQL query instead of writing code.

I learned SQL by looking at the...

Even with DataDude (VS Database Pro) there's no real integration with VSS as with .NET languages. What you could do is use VS with the db powertools to generate...

Ah - repotying errvices or BI would have been better forums.

When you transfer the data into a recordset object - do a rowcount on that and if it exceeds your...

@@ROWCOUNT?

20 lines of test data - and 5 tables? Is this a school project?

If so - please research this yourself. If not - please post details as requested...