Forum Replies Created

Viewing 9 posts - 301 through 309 (of 309 total)

  • RE: TSQL using parameters does not use the index

    Paul White (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    And it does not matter if you use uniqueidentifier or varchar(50)

    It is NVARCHAR(50).

    Do you really think there is no difference between indexing a GUID at 16...

    March 18, 2010 at 9:09 am

    #1136038

  • RE: TSQL using parameters does not use the index

    Tom Van Harpen (3/18/2010)

    When this table is loaded there are about 800,000 rows that all have the same batchExecID, the next run loads about the same but with a new...

    March 18, 2010 at 9:02 am

    #1136031

  • RE: TSQL using parameters does not use the index

    Paul White (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    Test again with 50000 unique GUIDs and a single GUID with 50000 copies.

    Now you are just being silly.

    Absolutely not.

    I believe that this is the exact scenario...

    March 18, 2010 at 8:05 am

    #1135977

  • RE: TSQL using parameters does not use the index

    GilaMonster (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    I find it is more helpful to suggest solutions rather than saying what not to do.

    I'll be very happy to give a solution once the actual execution...

    March 18, 2010 at 8:01 am

    #1135974

  • RE: TSQL using parameters does not use the index

    Paul White (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    The reason your example worked was not that you used UNIQUEIDENTIFIER instead of string, it was that you had a unique index and you had no...

    March 18, 2010 at 7:57 am

    #1135968

  • RE: TSQL using parameters does not use the index

    GilaMonster (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    Anyway, I do not think you will ever have range scans with GUID:s. Looking up a specific value will work perfectly even if the index is heavily...

    March 18, 2010 at 7:52 am

    #1135961

  • RE: TSQL using parameters does not use the index

    GilaMonster (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    Sure, why not ? The only possible ill effect is that it might slow down insertions to the table slightly. This will only be a problem if...

    March 18, 2010 at 7:36 am

    #1135941

  • RE: TSQL using parameters does not use the index

    Paul White (3/18/2010)

    stefan.gustafsson 60897 (3/18/2010)

    The easiest way to fix the problem is to make the index clustered instead of non-clustered. This would definitely solve the problem.

    :blink: You want to create...

    March 18, 2010 at 7:19 am

    #1135927

  • RE: TSQL using parameters does not use the index

    The easiest way to fix the problem is to make the index clustered instead of non-clustered. This would definitely solve the problem.

    If it for some reason is impossible to change...

    March 18, 2010 at 6:51 am

    #1135899

Viewing 9 posts - 301 through 309 (of 309 total)