Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 8,416 total)

  • RE: TSQL Lookup using BETWEEN (Ip Addresses)

    r5d4 (4/12/2010)

    Anyone got any ideas to improve on this?

    My tables are below. For reference, my IPcountrylookup table has 108726 rows

    and I've recorded 22515504 unique IPs so far.

    I realise I'm...

    April 14, 2010 at 2:41 am

    #1151171

  • RE: Join strategy

    Stefan_G (4/14/2010)

    Paul, I find your knowledge of the internal workings of SQL Server very impressive.

    How do you know all this internal stuff ?

    Thanks very much, Stefan. For anyone interested...

    April 14, 2010 at 2:01 am

    #1151155

  • RE: Understanding and Using APPLY (Part 1)

    karyn.webb (4/13/2010)

    Thank you Paul, really good reading and a great help in getting my head around yet another new concept. And they're all new right now so the clarity is...

    April 13, 2010 at 11:28 pm

    #1151130

  • RE: NULL

    Peter Trast (4/13/2010)

    So if I connect via command line, I can query the status of all of my ON/OFF options and they will all be off until I connect... SSMS...

    April 13, 2010 at 8:19 pm

    #1151102

  • RE: NULL

    Hugo Kornelis (4/13/2010)

    "Assuming ANSI_NULLS are on in your SQL Server database, which they are by default..."

    Okay, I admit it - this snippet in the explanation is actually correct.

    You'll be relieved...

    April 13, 2010 at 5:40 pm

    #1151076

  • RE: Today's Random Word!

    [font="Arial"]Ï räthër lïkë thë ümläüts[/font]

    April 13, 2010 at 5:27 pm

    #1151071

  • RE: Don’t Change Anything

    GabyYYZ (4/13/2010)

    ...but then the rational part of my brain kicks me in the groin...

    Odd anatomical image :laugh:

    April 13, 2010 at 5:21 pm

    #1151069

  • RE: Question about sort order for default Latin1_General_CI_AI collation

    SQLDS (4/13/2010)

    Thanks Paul. Given that, as you way, "using a given collation compares and sorts string data in the way expected by people", I'm still not sure what "people" would...

    April 13, 2010 at 5:11 pm

    #1151066

  • RE: Join strategy

    Gianluca Sartori (4/13/2010)

    I repeated the tests including you recommendations (join order, maxdop, unique index) and, without any other hint, the optimizer decides to go for a HASH join. If I...

    April 13, 2010 at 5:08 pm

    #1151065

  • RE: Join strategy

    RBarryYoung (4/13/2010)

    The general rule of thumb is (and always has been, as far back as I can recall) is that as long as at least one side has unique matching,...

    April 13, 2010 at 4:53 pm

    #1151059

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

    April 13, 2010 at 4:15 pm

    #1151050

  • RE: Join strategy

    Hey Gianluca,

    The answer is that it depends.

    First, though, let me compare my results to yours.

    Using HASH, I get 6s CPU and 26s elapsed.

    Using MERGE, I get 1.5s CPU and 1.6s...

    April 13, 2010 at 5:20 am

    #1150615

  • RE: Understanding and Using APPLY (Part 1)

    colgateway (4/12/2010)

    ...Then I downloaded your code and ran it. Same exact error.

    The code you used doesn't quite match 'Query 08' in the download file - did you edit it?

    The published...

    April 12, 2010 at 7:19 pm

    #1150456

  • RE: Understanding and Using APPLY (Part 1)

    JJ B (4/12/2010)

    This is the best article on APPLY that I've read. I particularly appreciate the paragraph: "APPLY calls the function once for each row from the input. ...to...

    April 12, 2010 at 4:49 pm

    #1150423

  • RE: Understanding and Using APPLY (Part 1)

    dbowlin (4/12/2010)

    I will join the praise of the article. Very thought provoking. I am looking forward to Part II and I am wondering if I am going to...

    April 12, 2010 at 4:46 pm

    #1150422

Viewing 15 posts - 3,856 through 3,870 (of 8,416 total)