Forum Replies Created

Viewing 15 posts - 496 through 510 (of 7,636 total)

  • RE: Today's Random Word!

    CirquedeSQLeil (4/14/2010)


    Tom Brown (4/14/2010)


    Mendelssohn

    Bach

    "I'll be Bach."

  • RE: Understanding and Using APPLY (Part 1)

    mishaluba (4/14/2010)


    The article is great and the pictures made it so much better! Other columnists should try to adapt this approach too!

    The problem with the articles here at SSC,...

  • RE: Comparing Table Variables with Temporary Tables

    Tom.Thomson (4/14/2010)


    RBarryYoung (6/15/2009)


    GilaMonster (6/15/2009)...No one I've spoken with knows exactly where the estimate is coming from. It's not the 30% of the table that's used with inequalities when a estimate...

  • RE: T-SQL Tuesday #5 Suggestions

    I suspect that Steve would like to host one in the future, and as the Host supplies the Topic, he is just soliciting suggestions for a good topic. I...

  • RE: Today's Random Word!

    CirquedeSQLeil (4/13/2010)


    ¿

    ++

    ++

    SFOp

    There's no call for that kind of language, Jason. 😛

  • RE: PATINDEX one set against another?

    Glad we could help.

  • RE: Are the posted questions getting worse?

    RBarryYoung (4/13/2010)


    Roy Ernest (4/13/2010)


    That someone has a Black belt... Watch out... :hehe:

    Yeah, but I have mad Ninja skills... they'll never see me coming ...:cool:

    Fyi: NINJA = No Income,...

  • RE: Are the posted questions getting worse?

    Roy Ernest (4/13/2010)


    That someone has a Black belt... Watch out... :hehe:

    Yeah, but I have mad Ninja skills... they'll never see me coming ...:cool:

  • RE: Understanding and Using APPLY (Part 1)

    korolana (4/13/2010)


    Nice article, but what is an advantage to use this approach vs simple join?

    From the performance point of view I don't think that calling UDTF on every row of...

  • RE: Today's Random Word!

    ChrisM@home (4/13/2010)


    Jabberwocky.

    Had to look up coolats, which are known as culottes here. They're revolting, talk about the worst of both worlds!

    Gödellian too. Meh. Must read more.

    Yes, they're notorious. The...

  • RE: PATINDEX one set against another?

    This should do it:

    ;WITH ctePatterns AS

    (

    SELECT ProjectName as Pattern

    FROM #myTableOfProjectsByName

    UNION --note: if you...

  • RE: SQL 2005 to SQL 2005 Linked Server problem

    Toby White (4/13/2010)


    Why do you think that Linked Servers are any less secure than Replication or OpenRowset?

    Replication is more secure because it is managed, automated, and you can use...

  • RE: Index suggestion for VERY large table

    TheSQLGuru (4/13/2010)


    RBarryYoung (4/13/2010)


    TheSQLGuru (4/13/2010)


    RBarryYoung (4/13/2010)


    TheSQLGuru (4/13/2010)


    Why bother converting the int to date at all? Every human can read and understand 20100411 is April 11 2010. 🙂 And if...

  • RE: Clustered index scan versus seek

    Can you post query plans that we can look at (actuals in *.sqlplan preferred)? There probably a statistics/rowcount difference that is leading it astray.

  • RE: Are the posted questions getting worse?

    Roy Ernest (4/13/2010)


    RBarryYoung (4/13/2010)


    Yikes!!! (Exit, stage left ... ) :w00t:

    You know something? I had the feeling that Gail would see your post ... 🙂

    Yeah, I also have a feeling...

Viewing 15 posts - 496 through 510 (of 7,636 total)