Forum Replies Created

Viewing 15 posts - 451 through 465 (of 465 total)

  • RE: Help! DB Performance down the tubes!

    OK. I usually monitor Stored Procedures - RPC Completed and TSQL - SQL Batch completed. In the Data Columns tab, defaults are usually fine. Makre sure TextData and Duration are...

  • RE: Help! DB Performance down the tubes!

    Turn on SQL Profiler, capturing the output to a table (this also has a cost, unless you're writing to another server). Make sure that you're getting the SQL/stored procedure calls,...

  • RE: preventing doubles to be entered, check for quite equal

    You might want to use initials. What will you do if you do have 2 John Walkers with same DOB?

    P

     

  • RE: Union query doesnt work. Please help

    Estuardo,

    Not sure if previous reply made it...sorry if this is a repeat.

    A few things:

    1) You need a datatype for col1 of your #tmp_table.

    2) I was able to do a similar...

  • RE: Union query doesnt work. Please help

    Estuardo,

  • RE: NULL vs. Empty String

    RE: Term_Date = 20790606 or 99991231.

    Just because we (presumably) won't be around on either of those dates doesn't mean they're safe to use. Somebody may be. Come that date, I...

  • RE: How to stop DB analysis from occuring

    BCC,

    This looks like the output from the startup of the SQL Server (you should see the last line in the SQL Server error log, as well -- one line for...

  • RE: Limit access to SQL Servers

    Hi Dave,

    OK, that's all good.

    Question 1) Can you tell who (which user) is connected to the server when they get there via the app?

    Question 2) If the app can connect...

  • 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 15 posts - 451 through 465 (of 465 total)