UPDATE dbo.Table SET Col = CASE WHEN Col IS NULL THEN 'some new value' ELSE Col END WHERE --filter ony required rows

muthukkumaran (5/20/2011)

---

Ninja's_RGR'us (5/20/2011)

---

GilaMonster (5/20/2011)

---

There is. See the Books...

GilaMonster (5/20/2011)

---

There is. See the Books item in...

Check the stats. One of the plan must estimate to return a crap load of data and decides to scan instead of seek.

Dan.Humphries (5/20/2011)

---

This is one of those DBs that make you want to bang you head on the wall. I do the isnull becuase there are records out there that...

I was thinking the same thing, but since...

Sean Lange (5/20/2011)

---

You know editing your original post and creating a new thread for the same thing isn't going to generate any new help. Your data is too sensitive and...

Any reasons why there's no filter on dates?? Other than tuning the db setup of hd I don't see much you can do to tune this. It's stilla...

I'm not trying to be un-kind in anyways but you need to get some training to learn this.

We can't do the job for you here and there's no way...

Can you post the actual plan and how much data is in each table (rows and pages).

That's all you need.

Be honest about your skills. Have an answer for I don't know but here's what I'd do to find out and how I'd resolve the issue.

Nobody...

sp_rename

Never a better time to say...

I don't know why but I was under the impression that there was a free ebook version of 1 on his books.

ChrisM@home (5/20/2011)

---

It's not as tough as it looks Ninja - it's an INSERT from a SELECT,...