Re: DB Architecture Questions (for joe celko)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

(sqlguru@xxxxxxxx) writes:
Question about the celko approach....
Take a simple user table for an example. In this case, if the only
"valid" unique identifier is the email address instead of a user_id,
the Celko's approach would have you use the email address as the
foreign key.....isn't a seek by a non-numerical value more expensive
than a numerical one??

More exactly, string columns are slower, since you have to take all
the collation rules into consideration.

Also, regarding the DAL.....access to methods are controlled within
the application layer. The DBA Team writes the ad-hoc queries (so they
are optimized) and send to the application architects to integrate
into the DAL. Because the DB model is based of the Business object
model, we know which columns are being used etc and we get full IDE
support (intellisense, reflection, dependancy check, compile-time
protection).

Not that I know how your model works, but since the IDE does not know
what is in those query strings, I doubt that you have full control
over column usage.

Regarding the statement about using SP because it's easier to quickly
fix a bug.....in an enterprise environment, you never "quickly" fix a
bug. Everything is documented and has to go through a CMI request and
tested etc.

When the system has grinded to a standstill? Or when users need to
get that report, register that trade, whatever, NOW?

Of course, if the system you work is not business-critical, you can
afford the luxury of being rigid.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: mssql ide (front ide)
    ... >Is there any front IDE for MS SQL as there is MySQL Front for MySQL. ... Each server doesn't necessarily need a dedicated IDE. ... The most obvious IDE for MS Sql server is MS Access which, ...
    (comp.databases.ms-sqlserver)
  • Re: Made a big mistake - VPN and RPC over HTTP (SBS 2003 Prem.)
    ... Should fix ISA and SQL all at the same time. ... Tried to fix SQL Server 2005 Express - no good. ...
    (microsoft.public.windows.server.sbs)
  • Re: Upgrading from SQL 7 to SQL 2000 - Setup Fails
    ... You have to copy the entire SQL 2000 CD to the server. ... > Cannot Connect to SQL Server ... > The install fails when it tries to run scripts. ... > a fix gives a bogus ftp: ...
    (microsoft.public.sqlserver.setup)
  • Re: Made a big mistake - VPN and RPC over HTTP (SBS 2003 Prem.)
    ...  Should fix ISA and SQL all at the same time. ... Remote Connection Disk, got into ISA 2004 and set it for VPN, then ran ... seeing errors about SQL. ... it uses SQL Server 2005 Express. ...
    (microsoft.public.windows.server.sbs)
  • RE: Unable to install KB954606
    ... have downloaded the HOT FIX KB954606 to shorten time between ... When run, it asks me to UNLOCK the SQL - so I turn it off - then it fails, ... BTW I can't find the Remote Registry Service, so I found (in Program Menu ... under SQL) the SQL Server Surface Area Configuration to start and stop it. ...
    (microsoft.public.windowsupdate)