Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 19,560 total)

  • RE: Extra join is killing query

    Looking over the code and the execution plans, it seems to me that the query is waaaaay over-complicated.

    Several of the joins appear to be unnecessary and can be handled properly...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 10:17 pm

    #1814626

  • RE: Extra join is killing query

    DavidDroog (7/22/2015)

    Hi Guys

    I have figured this out. My theory is that adding the extra table somehow screwed up SQL Servers execution plan so badly no amount of indexing etc was...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 9:59 pm

    #1814625

  • RE: Extra join is killing query

    DavidDroog (7/22/2015)

    Hi Drew

    I am a human and I disagree. I find it much easier to follow when the clauses are with the table joins.

    To each their own...

    Regards

    David

    I find it to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 9:55 pm

    #1814624

  • RE: Today's Random Word!

    J Livingston SQL (7/23/2015)

    SQLRNNR (7/23/2015)

    J Livingston SQL (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    DonlSimpson (7/23/2015)

    Ed Wagner (7/23/2015)

    J Livingston SQL (7/23/2015)

    Revenant (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    SQLRNNR (7/23/2015)

    cowboy

    dichotomy

    Opposition

    antithesis

    Conflict

    Resolution

    Clarity

    coherent

    disorderly

    conduct

    steward

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 3:26 pm

    #1814592

  • RE: Today's Random Word!

    J Livingston SQL (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    DonlSimpson (7/23/2015)

    Ed Wagner (7/23/2015)

    J Livingston SQL (7/23/2015)

    Revenant (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    SQLRNNR (7/23/2015)

    cowboy

    dichotomy

    Opposition

    antithesis

    Conflict

    Resolution

    Clarity

    coherent

    disorderly

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 3:04 pm

    #1814585

  • RE: Are the posted questions getting worse?

    Sean Lange (7/23/2015)

    I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

    MVXJDTA.MPDOPE.POOPNO

    Seriously that...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 1:40 pm

    #1814540

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/23/2015)

    SQLRNNR (7/23/2015)

    Brandie Tarvin (7/23/2015)

    Sigh. I feel like I'm pulling teeth on this forum some days.

    Are you now toothless then?

    No, but I'd love to be a Night Fury. @=)

    Ha...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 12:23 pm

    #1814514

  • RE: Issue to restore Bak file to MS SQL 2008

    Eddie Wuerch (7/23/2015)

    To get the list of database files in the backup (you will need to provide a new physical location for each file using the MOVE TO clause):

    ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 12:21 pm

    #1814510

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/23/2015)

    Sigh. I feel like I'm pulling teeth on this forum some days.

    Are you now toothless then?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 12:17 pm

    #1814506

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (7/23/2015)

    Just a thought,but don't you love your job when:

    a) you observe your systems for a while, then make one small change that improves performance significantly and massively reduces...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 11:15 am

    #1814469

  • RE: Today's Random Word!

    cowboy

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 11:03 am

    #1814464

  • RE: Are the posted questions getting worse?

    GilaMonster (7/23/2015)

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Woot Woot

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 10:49 am

    #1814459

  • RE: Are technical phone interviews pointless?

    dweil (7/23/2015)

    Who really cares if they are looking up the answer on the internet. The idea is to see how they would approach /solve a particular problem/solution. If they look...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 23, 2015 at 10:48 am

    #1814457

  • RE: Issue to restore Bak file to MS SQL 2008

    sendtog.roy (7/22/2015)

    Hi

    i am trying to restore bak file using the following query

    <

    RESTORE DATABASE WTS

    FROM DISK = 'C:\Gautam\WTS_BLR_PRE_LOADTEST.BAK'

    WITH MOVE 'WTS_Data' TO 'C:\Program Files\Microsoft SQL ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 22, 2015 at 4:15 pm

    #1814248

  • RE: Today's Random Word!

    Moreau

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    July 22, 2015 at 1:16 pm

    #1814202

Viewing 15 posts - 1,126 through 1,140 (of 19,560 total)