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

That's strange. If it was a default instance before, it still should be.

Have you restarted the host? Not that it matters, but just wondering. Otherwise, not sure why you're seeing...

Certainly things can (and probably should) change after installation. However, perhaps you should have some idea of what defaults you want. This is more the settings, am I using Filestream?...

No need to do anything. Nothing is being enforced by code

Stefan Krzywicki (10/9/2014)

---

Had a great SQL in the City yesterday. I now have a lot to read and a lot more to research. Great seeing Jack and Grant again and...