Forum Replies Created

Viewing 7 posts - 451 through 457 (of 457 total)

  • RE: Deadlocks

    Thanks for the replies.

    No, no temp tables used.

    Steve, I will try to set the alert, however, these deadlocks only occur under very high load, which typically only happens once or...

  • RE: Limit access to SQL Servers

    Hi all,

    Thanks for the input.

    Application roles: Don't want to do this, we are aiming for *really* thin clients, all business rules (including security) on back-end. Also, from what I have...

  • RE: linking fields in queries

    Sounds like a subquery...

    Something like

    SELECT <some fields>

    FROM <some tables> as st1

    JOIN (SELECT <some fields>

    FROM <some other tables>) AS st2 ON st2.<field> = st1.<field>

    Now,...

  • RE: linking fields in queries

    Sounds like a subquery...

    Something like

    SELECT <some fields>

    FROM <some tables> as st1

    JOIN (SELECT <some fields>

    FROM <some other tables>) AS st2 ON st2.<field> = st1.<field>

    Now,...

  • RE: Strange behaviour

    5409045121009 and whoteegan:

    Thank you for the replies.

    Raiserror in sproc #3 is handled correctly. No results are returned to the application, and the error message is displayed where expected.

    whoteegan: Application not...

  • RE: Multiple table insertion

    Sounds like a index problem, as in lack of useful indices. You don't mention any in your post.

    Also, I'm not sure, but it appears that ExclusionList might not be normalized....

  • RE: query analizer

    Not enough information to make a meaningful diagnosis: How do you know your query should execute faster? A 'simple' select statement on a 50-million row table with no indexes could...

Viewing 7 posts - 451 through 457 (of 457 total)