Christopher Stobbs (2/3/2009)

---

The percentages look small on the key lookups but I'm sure I've read somewhere that the percentages are not always accurate with regards to some of the operators...

First thing I see is several key lookups on the PS_IN_DEMAND table to get QTY_REQUESTED_BASE & QTY_BACKORDER_BASE columns. You could add these as an INCLUDE...

GilaMonster (2/3/2009)

---

Grant Fritchey (2/3/2009)

---

This is going to cause the query to run slow since it has to run this query for every row of data in the FROM clause. Best...

Eh! If I must.

Maybe something...

While waiting for the execution plan (actual, not estimated please), I looked through a bit of the code.

This is going to cause the query to run slow since it has...

It was good for a giggle.

I think a different theme next time. Any Babylon 5 fans?

idrees.butt (2/3/2009)

---

and the thing is that when I read common mistakes...I cant appreciate them since I dont know whats the correct way of doing that thing...what to do in this...

idrees.butt (2/3/2009)

---

Can you give a general, simple and very good example of how to do that shift? like an alternate way(column wise thinking) to what a normal person would do...

Can you post the Connect link here please? Others that might run into the problem will want to raise it's importance and anyone else that hits the problem is going...

OK. I was pretty sure of this, but I wanted to verify it. We don't use the Wizard for deployments. Instead we deploy to the file share referenced by the...

Unfortunately no. We haven't been using the 2008 Wizard for installations, yet. I'll check with our local SSIS guy to see if he has any ideas.

You want deletes in the transaction log. That's how you can do a rollback if there is a problem. Plus, transaction processing is an essential part of the system maintaining...

Yep. It can be done. We're using it as part of our migration plan too. I didn't do the setup myself, but I can ask the guy who did it...

With linked servers I almost always do one of two things. Put the entire load on the linked server, meaning, perform all the joins, etc. on that machine and get...

Can you post the actual execution plan? Simply looking at a slice of the code we may or may not be able to identify an issue, but looking at the...