Congrats, Grant

Luis Cazares (10/14/2014)

---

That sounds like a good and bad news. And the good news sound great.

Thank you for the update, Steve.

In an unrelated topic, have you ever seen a code...

Unbelievable. Giants can't score, not even a FG, SD decides not to play defense against the Raiders, and Manning has a pedestrian day, ignoring Sanders for the most part.

(shakes head)

OK, I'm still slightly confused, but I think you mean you have a source where you have everything, all records. However you only want the latest time for an event...

Thanks, a couple updates.

We implemented ASKIMET for posts. This took effect today and shouldn't slow things down, but we are evaluating and discarding SPAM posts. Let me know if things...

Ed Wagner (10/14/2014)

---

Yes. Some days last week were slow as well. Quote was particularly...

Is quoting and general access slow for anyone else today?

In terms of the how you do this, lots of ways, but the why isn't listed. If you don't want dupes, then can you explain a bit more about what...

Jeff Moden (10/14/2014)

---

The problem with adding to procs to "update" the audit table is that if the audit table changes, you must find and update all those procs or, perhaps,...

The best practice, IMHO.

Good luck, and if things don't split, you'll be fine either way.

SQL Compare does a great job, and good luck with it.

Disclosure: I work for Red Gate, which makes SQL...

You can use triggers on your tables. However I'd refactor my procs to add a second update (in the same transaction) that updates the audit table with values.

select

lastname

, updateddate

from log

order by updateddate

is what you can do.

No, your design is not off, but you should consider the case where I separate a mart or ODS from the ETL store or other DW. In that case, do...

You cannot order a table. A table is a set of rows (tuples I think) and has no order.

ORDER BY is a function of data retrieval (SELECT), not storage.