Re: Throwing this out there for discussion
From: Pablo Sanchez <pablo_at_dev.null>
Date: Tue, 28 Jan 2003 07:49:29 -0600
Message-ID: <Xns9311456D4411Bpingottpingottbah_at_216.166.71.233>
>
> In addition to Dan's suggestion, and the important corollary added
> by soul survivor that if there is no db documentation then the
> chances are that there is little or no db design. You can also trace
> a specific workstation's session doing specific tasks and see what
> the SQL issued by the app is doing. This won't work without a
> dedicated server connection obviously.
Date: Tue, 28 Jan 2003 07:49:29 -0600
Message-ID: <Xns9311456D4411Bpingottpingottbah_at_216.166.71.233>
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in news:3e365409$0$234$ed9e5944_at_reading.news.pipex.net:
> "Tom Swier" <tswier_at_yahoo.com> wrote in message
> news:8098db11.0301271130.17f0aac8_at_posting.google.com...
>> I had a person ask me this and I stood there like an idiot because I >> couldn't answer their question due to all the foot-shuffling and >> hemming and hawing. I thought I had it bad!
>
> In addition to Dan's suggestion, and the important corollary added
> by soul survivor that if there is no db documentation then the
> chances are that there is little or no db design. You can also trace
> a specific workstation's session doing specific tasks and see what
> the SQL issued by the app is doing. This won't work without a
> dedicated server connection obviously.
I would 'test drive' an ERD tool and also reverse engineer the app. This way I might get a visual on it.
-- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.comReceived on Tue Jan 28 2003 - 14:49:29 CET