sunny.tjk (4/5/2012)

---

GilaMonster (4/5/2012)

---

You could, just watch the IO impact.

Lots of database snapshots can have a serious impact on data modifications in the source DB. By lots, I don't mean...

kathyoshea (4/5/2012)

---

Thanks for your reply. I ended up re-creating the job. The box was unchecked, but I kept getting the email message. Re-creating it worked, but it wasn't a good...

From Books Online:

When the AUTO_UPDATE_STATISTICS database option is set to ON (the default), the query optimizer automatically updates this statistical information periodically as the data in the tables changes. A...

The statistics may not be as good as they could be? See my previous post.

Grant Fritchey (4/5/2012)

---

Lynn Pettis (4/5/2012)

---

Grant Fritchey (4/5/2012)

---

Look at it as a complement. To many people, we're...

ggjjbb1983 (4/5/2012)

---

If a data import has caused a plan to re-compile - would this not improve performance,as the engine will now be aware of the extra data?

I'm seeing a...

Grant Fritchey (4/5/2012)

---

Look at it as a complement. To many people, we're the SQL Server documentation....

I'm sorry, but I started laughing to myself when I read this one.

S_Kumar_S (4/5/2012)

---

A bad update can be anything that makes the data which it should not be. e.g. someone running update statement without where clause or someone updating incorrect values e.g....

Okay. Just 2 more cents here, if you (and no one else at the company) can not change the database, then it really should be incumbent on the third...

capn.hector (4/4/2012)

---

SQLRNNR (4/4/2012)

---

Lynn Pettis (4/4/2012)

---

Well, apparently we can't accept the restrictions he has to work under...

You need...

peter 82125 (4/4/2012)

---

Right. No changes to the database. Nothing. Zilch. Nada. No new tables, new indexes, triggers, nothing. All I can do is read what's in there. Absolutely nothing else....

GilaMonster (4/4/2012)

---

dfrome (4/4/2012)

---

My question is now that DBCC comes back clean, I know there's still corruption somewhere in there and it's just a matter of time before SQL reallocates to...

Try this. The only issue it may have is if the subquery returns more than one row.

update tbl_newPeople

set idDocument =

(select A.idDocument

...