Re: Database design question - Isolated, unrelated tables

<nyathancha_at_hotmail.com> wrote in message news:1182820095.745339.128220_at_e9g2000prf.googlegroups.com...

> One good point everyone seems to raise is "what is it used for?" ...
> To be perfectly honest I am not entirely sure myself. Its one of those
> requirements that filtered down from the management cloud. I think
> the view is to use it mainly for "reporting" kind of functionality and
> maybe only on some rare occasion for some sort of postmortem
> debugging. Although in the latter situation, the application logs and
> the sql server logs will probably end up being more helpful. I think
> there is a system table somewhere in sql server that logs all the
> transactions and changes that happen in the table right?
>

In architecture, form follows function. If the question "what is this data being captured for" is unanswered, then the question of whether the design is appropriate becomes moot. Received on Mon Jun 25 2007 - 20:28:24 CDT