Forum Replies Created

Viewing 10 posts - 16 through 25 (of 25 total)

  • RE: Expanding The Scope of Bridge Tables

    David Portas (3/23/2010)


    Ed-997158 (3/23/2010)


    Thanks. I was just going to ask if "bridge table" didn't already have a different terminology

    "Associative Entity" is semantic modelling terminology and not a relational database...

  • RE: Expanding The Scope of Bridge Tables

    Reading this article makes me very nervous. I've seen so many performance issues arise from approaches similar to this. While you didn't make a statement on it, most readers might...

  • RE: The R2 Penalty

    Microsoft already offers a range of licensing agreements.

    For companies who develop s/w that use SQL (Independant S/W Vendors (ISV's) they can sign a license agreement that lets them continue...

  • RE: Keeping It All In Memory

    For the niche solutions you mention above check out the StreamInsight component that ships with SQL Server 2008 R2 (currently in beta (as of Feb 2010)).

    I think you'll find it...

  • RE: Keeping It All In Memory

    Jason,

    As hinted above, be very careful with SSD manufacturer quoted perf numbers.

    SSD drives all perform brilliantly when first installed. But over time you start to notice a massive...

  • RE: Keeping It All In Memory

    Part2:

    The other common use for IMDB is Complex Event Processing. The desire to process data first & only log some, none or all of the changes async. ie have minimal...

  • RE: Keeping It All In Memory

    I can't comment on what the SQL Team are thinking now. But can say the idea of an in-memory DB is not new & is something Microsoft has invested a...

  • RE: SQL Server vs. JET

    On Cost: MS already makes a version of SQL (Express) with the limits removed that it embeds with other its other products. The SQL in Small Business Server version...

  • RE: SQL Server vs. JET

    May be worth noting that JET (Blue) used by Exchange is a very different beast to JET (Red) which is used by Access.

    Both JET projects started in the late 1980's....

  • RE: SQL Server vs. JET

    In the mid '90's MSFT did an audit & found it was developing 42 different database engines, most used internally for features within each product. So the paper recommended they...

Viewing 10 posts - 16 through 25 (of 25 total)