June 20, 2007 at 9:42 am
First question : data warehouse or transactional database (reporting or working)?
June 20, 2007 at 10:34 am
the most important point is that most databases and applications are often not well written for any number of reasons. If the performance of the database is bad then fair comment but the points you raise are unlikely to degrade performance.
RFI is always good but there could be good reasons why there isn't any - as for compound PK's - well to be blunt, without any knowledge of the application or database you are saying this is wrong - you probably won't make many friends with this approach - it's too long a discussion as to PK choice - and another thread - I tune apps/databases for a living - I work on the basis thta most customers want improvements and life's like that, databases are often bad.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 20, 2007 at 10:44 am
Nice pragmatic approach, I agree with it entirely!
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply