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

It sounds like you're locking the resource and then blocking all others, not like a deadlock. Leave the deadlock monitors in place, but you should take a look at the...

The thing is, MAXDOP is a way to limit paralellism. A lot of times, in the OLTP type systems I work in, parallel queries cost more than they provide benefit....

Why do you want to mess with MAXDOP? Your default setting is 0, which means that SQL SErver will use as many processors as it has available to it. Maybe...