Forum Replies Created

Viewing 15 posts - 226 through 240 (of 658 total)

  • RE: CTE

    Carlo Romagnano (9/26/2013)

    On my server sql2008 r2 my script runs in 2 seconds vs 6 secs of Lynn's.

    The difference is because you've added an extra join so are returning more...

    September 26, 2013 at 4:19 am

    #1653481

  • RE: Executing Dynamic SQL

    ksatpute123 (9/25/2013)

    Comments posted to this topic are about the item <A HREF="/questions/Dynamic+SQL/102252/">Executing Dynamic SQL</A>

    Nice idea, but not sure about the execution. I knew it was going to fail due to...

    September 26, 2013 at 2:23 am

    #1653450

  • RE: CTE

    Carlo Romagnano (9/25/2013)

    ... and you do not need semicolon.

    But at some point in the future you will need a semi-colon for everything. Best practice IMO is to use them for...

    September 25, 2013 at 4:26 am

    #1653046

  • RE: CTE

    Carlo Romagnano (9/25/2013)

    With complicated CTE, the optimizer does not choose the best plan.

    I have sometimes found that as well.

    I have also occasionally found the opposite, where using a CTE has...

    September 25, 2013 at 4:24 am

    #1653045

  • RE: Dynamic Query

    I got this wrong because I assumed the "*/" was only on a new line because it had been wrapped by the narrow display 🙁

    September 24, 2013 at 2:04 am

    #1652593

  • RE: Variable Declaration

    Leifton (9/19/2013)

    Not sure how everyone is getting this right. The script fails (as i suspected) in SQL 2005, 2K8 and 2K12. Since the first block is not run...

    September 19, 2013 at 5:39 am

    #1651456

  • RE: Variable Declaration

    I'd never have got this right if it weren't for the discussion following the other recent variable declaration question!

    Interesting to know how SQLServer behaves - but hopefully such shoddy code...

    September 19, 2013 at 2:35 am

    #1651405

  • RE: Reserved Words - 1

    L' Eomot Inversé (9/18/2013)

    I think that wa the point of the question: the seting of quoted_identifier only affects the treatment quote marks as delimiters. not the treatment of square brackets.

    You're...

    September 18, 2013 at 9:04 am

    #1651152

  • RE: Reserved Words - 1

    Nice question, but I can't understand why the stuff about quoted identifiers is in the explanation. Surely the result is identical even if QUOTED_IDENTIFIER is On?

    September 18, 2013 at 1:58 am

    #1651012

  • RE: wildcards

    L' Eomot Inversé (9/11/2013)

    Do you mean 80 messages or 400 messages or something in between? A count of pages is meaningless, since people set their forum view to have...

    September 11, 2013 at 7:58 am

    #1649313

  • RE: wildcards

    Dear Steve

    Can you change the points system so that if someone replies pointing out an error and 8 pages of people have already replied pointing out the same error in...

    September 11, 2013 at 6:44 am

    #1649260

  • RE: wildcards

    Todd Reddinger (9/11/2013)

    The correct answer is 0 since 'steppenwolf' is 11 characters long and would return an error.

    It's amazing that in 7 pages of discussion, you're the first person to...

    September 11, 2013 at 5:47 am

    #1649223

  • RE: wildcards

    Raghavendra Mudugal (9/11/2013)

    I just analyzed the question without executing and picked the right answer.

    You clearly didn't analyse it very well then 😉

    September 11, 2013 at 3:09 am

    #1649155

  • RE: Behavior of trigger

    Stewart "Arturius" Campbell (9/10/2013)

    another notch to my list of reasons to dislike triggers

    Really? Can't say this behaviour would appear anywhere on my list of bad things about triggers. I've...

    September 11, 2013 at 2:47 am

    #1649144

  • RE: wildcards

    Koen Verbeeck (9/11/2013)

    Indeed. As if I'm going to count the number of characters in Steppenwolf.

    Why wouldn't you? I did, and got it wrong as a result.

    I was guessing though, as...

    September 11, 2013 at 2:04 am

    #1649132

Viewing 15 posts - 226 through 240 (of 658 total)