Lynn Pettis (2/3/2009)

---

GilaMonster (2/3/2009)

---

Nah. You're not the only one. That's...

Backups, first, last & always. You can't be paranoid enough.

Also, are your databases in simple recovery mode or full? If full, you need to come up with a log backup...

We live for the one. We die for the one.

HA! Ya'll are in trouble now.

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