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.

Access works well for this if it's a limited number of people.

If not, you could do something like this: http://www.sqlservergeeks.com/sql-server-using-sql-server-reporting-services-to-manage-data/

Not sure. I wasn't sure how to frame this, but I've seen the concatenation question regularly, and sometimes with some aggregation or summary (like counting responses and listing them).

Denormalize responses...

No hurry. If you can get in weeks, that would be good. Months, people tend to forget about things.

Happy to help, but this really looks like a homework issue, and we prefer to help you once you've tried something, rather than giving you some answer.

A few hints. First,...