Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 8,753 total)

  • RE: Stop query if it is taking too long

    mah_j (10/22/2016)


    I am so sorry,I asked my question in a wrong way.Yes I know that we have problem in one of our queries,and I am involved.(The logical io is...

  • RE: Stop query if it is taking too long

    GilaMonster (10/22/2016)


    Eirikur Eiriksson (10/22/2016)


    GilaMonster (10/22/2016)


    Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.

    This approach...

  • RE: Procedure Cache Hit Ratio

    MVP_enthusiast (10/22/2016)


    Last night I just migrated one of my busiest databases from SQL 2008 to 2012. Max server memory allocated to SQL Server In 2008 was 50000 and now in...

  • RE: Are the posted questions getting worse?

    Jeff Moden (10/22/2016)


    Eirikur Eiriksson (10/20/2016)


    Gazareth (10/19/2016)


    Eirikur Eiriksson (10/18/2016)


    Just had a Blast from the past

    😎

    First line: "Version 4.2 also lets you nest triggers"

    I didn't get any further due to blacking out;...

  • RE: Stop query if it is taking too long

    GilaMonster (10/22/2016)


    Set the app's timeout to 40 seconds (how depends how the app connects to SQL). What you ask is exactly what an application timeout is.

    This approach could possibly leave...

  • RE: Query to show duplicate values

    patelxx (10/22/2016)


    Many Thanks for the reply - it really worked for my results set, please can explain the below section of the code for my understanding:

    NUMBERED_INSTANCES AS

    (

    ...

  • RE: Stop query if it is taking too long

    mah_j (10/22/2016)


    Hello

    How can I stop the long running query that is run from application?

    I want to kill the queries that are running longer than 40 seconds.

    Do you want to automatically...

  • RE: Query to show duplicate values

    patelxx (10/22/2016)


    What query can I ran to show duplicate values? I know if I use the DISTINCT and UNION - this will remove duplicate values however I ONLY want...

  • RE: SSRS 2014 How to pass Multiple values with like operator in a parameter

    Hi

    and welcome to the forum,

    is there an option of doing this on the database side?

    😎

    There are several ways of passing multi value parameters, each has pros and...

  • RE: Are the posted questions getting worse?

    Gazareth (10/19/2016)


    Eirikur Eiriksson (10/18/2016)


    Just had a Blast from the past

    😎

    First line: "Version 4.2 also lets you nest triggers"

    I didn't get any further due to blacking out; came to 10 minutes...

  • RE: Remove almost Duplicate Records

    First a quick note, please read up on how to post questions on the forums as your data example has few problems, took longer to sort those than writing the...

  • RE: Today's Random Word!

    Stuart Davies (10/19/2016)


    Ed Wagner (10/18/2016)


    Ray K (10/18/2016)


    djj (10/18/2016)


    ZZartin (10/18/2016)


    Luis Cazares (10/18/2016)


    Manic Star (10/18/2016)


    djj (10/18/2016)


    Ed Wagner (10/18/2016)


    whereisSQL? (10/18/2016)


    Revenant (10/18/2016)


    crookj (10/18/2016)


    djj (10/18/2016)


    Grumpy DBA (10/18/2016)


    BWFC (10/18/2016)


    Current

    Currant

    Food

    Hungry

    Hungary

    Europe

    Brexit

    Vote

    Drink

    Martini

    Dirty

    Clean

    Mr.

    Anderson

    Tapes

    Backups

  • RE: update trigger get fields before and after update

    Jeff Moden (10/18/2016)


    Eirikur Eiriksson (10/13/2016)


    Further on Jeff's fine reply, here is an example of "Generic" table auditing with few extras for education and entertainment.

    Correct me if I'm wrong, please. ...

  • RE: log is full due to Availability Replica

    rkrpat (10/18/2016)


    Thanks for your suggestion... thought anyone could give an idea how and why AG replica goes to Not synchronising state in general.. getting consultant help is already done.. but...

  • RE: Recording data changes

    Bruce-12445 (10/18/2016)


    I have written triggers a long time ago so I'll give it a go and it all should come rushing back in.

    Correct me if I'm wrong: I'll create...

Viewing 15 posts - 3,031 through 3,045 (of 8,753 total)