Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Eliminating Windows Authentication

    Microsoft has stated their intent to remove anything but Windows authentication for SQL server so you may have to rethink this strategy.

  • RE: More sophisticated locking model

    quote:


    Fix: Uninstall SQL Server. Install Oracle.

    (I like these easy ones)


    Oracle has its own set...

  • RE: better locking model

    I have to say though, with the app your talking about, I am not big on hints and never have been.

    dovidf>

    I worked extensively in an Oracle environment prior to the...

  • RE: Using 'WITH(NOLOCK) to Improve Performance.

    NOLOCK should just affect the locking behavior and any slow downs due to waiting for locks to clear would be solved. If the incidence of lock contention is low, then...

  • RE: SQL Server VS. Oracle

    quote:


    In response to your last statement regarding milliseconds, this is exactly what I'm talking about. Everyone has something that somehow makes them...

  • RE: SQL Server VS. Oracle

    quote:


    Not being too familiar with PL/SQL, can you give an example? I've heard it is a more powerful languange, but not any...

  • RE: SQL Server VS. Oracle

    quote:


    Not being too familiar with PL/SQL, can you give an example? I've heard it is a more powerful languange, but not any...

  • RE: Uninterrupted access to databases

    The onely way to have true 24x7 is with multimaster replication which even Oracle parallel server doesn't really have. This would require one or many servers that can independently handle...

  • RE: LEFT OUTER JOIN PROBLEM

    replace AND (Customers.Acc_Type = Accounts.Type OR Accounts.Acc_Type = 'ALL')

    with

    AND (Customers.Acc_Type = Accounts.Type) OR (Customers.Acc_Type <> Accounts.Type and Accounts.Acc_Type = 'ALL')

Viewing 9 posts - 1 through 9 (of 9 total)