Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 19,564 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...

    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...

    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...

    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

    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

    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...

    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...

    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):

    ...

    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?

    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...

    July 23, 2015 at 11:15 am

    #1814469

  • RE: Today's Random Word!

    cowboy

    July 23, 2015 at 11:03 am

    #1814464

  • RE: Are the posted questions getting worse?

    GilaMonster (7/23/2015)

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

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

    Woot Woot

    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...

    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 ...

    July 22, 2015 at 4:15 pm

    #1814248

  • RE: Today's Random Word!

    Moreau

    July 22, 2015 at 1:16 pm

    #1814202

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