Casper (1/30/2009)

---

Well it's been over 5 hours now AND STILL running 🙁

Thanks for all your replies but I was now thinking: As mentioned it does UPDATES and INSERTS to...

Can you post the execution plans?

They're no good to me dead.

Things like this will lead to table scans, which will kill your performance:

WHERE

COALESCE(Last_live_insert_date, Last_booked_insert_date)

Profiler records when a proc, query or statement starts and when a proc, query or statement ends. It...

Except for the recursion, a CTE is really just a more sophisticated way to create sub-selects. So they're just as effective as the sub-selects were with the added value that...

So it's two different databases? You can join the tables together in a query by referrencing the database name, but you can't create a foreign key across databases.

You must be new in this galaxy.

Bruce W Cassidy (1/29/2009)

---

[font="Verdana"]Yup. I added a cross join as well. And the full outer joins...

Jack Corbett (1/29/2009)

---

All right, I've been essentially offline for 3 days and there are close to 100 posts on this thread AND IT has become self-aware!

My question is, was The...

GilaMonster (1/29/2009)

---

We...

Jean-François Bergeron (1/29/2009)

---

Wow, I did not know that. So when I receive a string, for a where Clause, like this one, for example:

CAST(MfrCode AS NVARCHAR(max)) LIKE 'tel%' AND

CAST(VendorCode AS NVARCHAR(max))...

Jean-François Bergeron (1/29/2009)

---

Grant, does the same behavior apply for the Cast keyword? Because the application we use sends me some dynamic SQL that is always Casted as nvarchar(max). Could that...

I've been a DBA, exclusively, for about 10 years now and no certification whatsoever. You just don't need one. Knowledge and experience are what really counts. If you have three...

Since the functions seem well in hand, I'll address other stuff.

You're using CONVERT on your columns in the WHERE clause. This will absolutely prevent the indexes, if any from being...