Forum Replies Created

Viewing 15 posts - 181 through 195 (of 824 total)

  • RE: Is XML the Answer?

    Absolutely.  I have now been on two different projects in which the developer teams both independently (I.e. without me beating them over the head) concluded that XML was poison when...

  • RE: Synonyms on a table

    Generally speaking DDL is not allowed on synonyms.

  • RE: Lookup Table Madness

    Your example is almost exactly the same as several that I have seen, and in cases with those very narrowly defined criteria, I have used MUCK tables.  They work for...

  • RE: Lookup Table Madness

    Saying that the database organizes data that reflects some part of the "real world" in no way implies that the things that the database manages information about have to be...

  • RE: Lookup Table Madness

    "How you store them depends on the app" sums up the problem quite nicely.  Applications come and go, data persists.  If you design your database too much around specific application functionality,...

  • RE: Lookup Table Madness

    You contradict yourself: How can it be OK to "combine thousands of lookup tables into one E-A-V table" but then in the next sentence you say "I can never see a...

  • RE: Lookup Table Madness

    I really couldn't care less if you call me pompous and arrogant, just don't call me wrong!

    HELLO, this article IS a biased "preach session."  I'm glad you at least grasped...

  • RE: Lookup Table Madness

    Just to follow up, the primary objection to MUCK tables has NOTHING to do with perormance, it has everything to do with logical correctness.  For me, performance is a secondary...

  • RE: Lookup Table Madness

    Yes and no...

    Dare I admit that I have actually used MUCK tables?  Yes I have, because I have had situations where we need to capture data that is given to...

  • RE: Lookup Table Madness

    I'm sorry you feel that way...

    I admit that if I had it to do over again, I could improve the article significantly, and will offer in my defense that I...

  • RE: download SQL server2005

    Since the official release, I don't believe that the beta versions are available for download.  You can download the trial version here:

    http://www.microsoft.com/sql/downloads/trial-software.mspx

  • RE: The Pitfalls of Foreign Keys

    That's one example of a possible performance hit that would be necessary in the absence of DRI. 

    The bigger problem is that you have orders for products that are not...

  • RE: The Pitfalls of Foreign Keys

    I won't attempt to provide a "better" design since I know almost nothing about the requirements for the system.  However, just looking at that particular diagram, several questions/objections spring to...

  • RE: Sybase linked server to MSSQL 200x very *slow*...

    That would tend to indicate that the queries being run by Crystal et al are not the same as the query you are running through SQL.  Are you sure they...

  • RE: Sybase linked server to MSSQL 200x very *slow*...

    You might try using pass through queries using OPENQUERY or OPENROWSET and see if that clears things up.

Viewing 15 posts - 181 through 195 (of 824 total)