Forum Replies Created

Viewing 15 posts - 106 through 120 (of 221 total)

  • RE: TSQL query slower with variable than hard-coded

    Thanks Gail, I'll try it in a stored procedure/with hints on Monday.

    Have a great weekend!

    April 1, 2016 at 10:21 am

    #1869227

  • RE: TSQL query slower with variable than hard-coded

    Putting everything into temp tables made the latter query (55s with the variable) quicker than the former (hardcoded). I'm a bit stumped.

    April 1, 2016 at 7:36 am

    #1869150

  • RE: TSQL query slower with variable than hard-coded

    It's VARCHAR(20).

    I can't without breaking company rules due to the table and field names...I'll find a moment this afternoon to recreate the issue using temporary tables and post the plans...

    April 1, 2016 at 5:50 am

    #1869112

  • RE: TSQL query slower with variable than hard-coded

    John Mitchell-245523 (4/1/2016)

    Does this happen every time, even after you clear the plan cache (don't do that on a production server, though)? Have you compared the execution plans for...

    April 1, 2016 at 5:36 am

    #1869103

  • RE: By date

    girl_bj (4/1/2016)

    I manage to run in every 7 days continuously. Added in ROW_NUMBER() OVER (ORDER BY startdate) AS Row too.

    How can I push this record as an output. I tried...

    April 1, 2016 at 3:36 am

    #1869084

  • RE: The Younger Generation

    mjh 45389 (3/24/2016)

    Gary Varga (3/23/2016)

    ccd3000 (3/23/2016)

    ...I'm an MIS major myself and I can think of only 2 or 3 classes that I still value.

    I think that most of the degrees...

    March 24, 2016 at 4:20 am

    #1867345

  • RE: The New Men of IT

    Gary Varga (3/23/2016)

    tindog (3/23/2016)

    Gary Varga (3/23/2016)

    You all jest but I know of one candidate who asked "Do you have a canteen? And is it subsidised?"

    Well, don't keep us all in...

    March 23, 2016 at 9:52 am

    #1867144

  • RE: The New Men of IT

    Gary Varga (3/23/2016)

    You all jest but I know of one candidate who asked "Do you have a canteen? And is it subsidised?"

    Well, don't keep us all in suspense. Is it...

    March 23, 2016 at 9:25 am

    #1867127

  • RE: parent/child relationships

    Could you post a clear representation of the output you'd like please? I gave it a go but got a bit confused with the description of what you'd like to...

    March 23, 2016 at 6:34 am

    #1867056

  • RE: The New Men of IT

    Can I leave early on Friday?

    March 23, 2016 at 5:41 am

    #1867039

  • RE: The New Men of IT

    Gary Varga (3/23/2016)

    tindog (3/23/2016)

    andrew gothard (3/23/2016)

    Jeff Moden (3/19/2016)

    GeorgeCopeland (3/19/2016)

    CV is a common business term and it is used extensively in academia. I prefer qualifications brief .

    Heh... I refer to both...

    March 23, 2016 at 5:17 am

    #1867032

  • RE: The Younger Generation

    DavidL (3/22/2016)

    tindog (3/22/2016)

    JesseBizInt (3/22/2016)

    I call myself an accidental dev because I ended up falling into a business intelligence role mainly through passion and not through any in-depth technical knowledge. ...

    March 23, 2016 at 5:15 am

    #1867031

  • RE: The New Men of IT

    andrew gothard (3/23/2016)

    Jeff Moden (3/19/2016)

    GeorgeCopeland (3/19/2016)

    CV is a common business term and it is used extensively in academia. I prefer qualifications brief .

    Heh... I refer to both a "CV"...

    March 23, 2016 at 4:58 am

    #1867026

  • RE: The Younger Generation

    Gary Varga (3/22/2016)

    Andy Warren (3/22/2016)

    ...I don't feel like schools do a good job of explaining what we do, or comparing it to what other professions do...

    In the UK schools haven't...

    March 22, 2016 at 7:34 am

    #1866771

  • RE: The Younger Generation

    JesseBizInt (3/22/2016)

    tindog (3/22/2016)

    I agree, and I think it does make everything a bit more daunting, especially when you're trying to decide whether to go down DBA/Analyst/developer routes. It sounds like...

    March 22, 2016 at 7:21 am

    #1866763

Viewing 15 posts - 106 through 120 (of 221 total)