Click here to monitor SSC SQLServerCentral is supported by Red
Gate Software Ltd. Log in  ::  Register  ::  Not logged in
Design Oversight - Preliminary Review  By Brian Kelley,
2001/08/20  Design Oversight - Preliminary Review  We all know
what the ideal application design environment is for building a
database back-end: an experienced DBA takes inputs from end
users and developers and creates the database design in order to
support the application being developed.  Stored procedures,
tables, views, indexes, the works, are all developed by DBAs
working closely with the programmers writing the application. 
Database best practices are the rule, not the exception.   But
in reality, we don't get the opportunity to do application
design like this very often.  The ideal is quickly shoved aside
and often developers are doing their own design and building
their own stored procedures and making decisions on constraints
and indexing in order to get an application out the door the day
before yesterday.  Meanwhile, th