How do I decide which column(s), if any, I should place my clustered index on?

  • Perry Whittle (10/24/2011)


    jared-709193 (10/24/2011)


    Yes, their view definition included the TOP and ORDER BY

    don't know how many times it's been said but "Don't order by in a view" 🙂

    A view is essentially a table, all ordering should be done outside the view

    This is straight from Microsoft

    http://support.microsoft.com/kb/926292

    lol... Preaching to the choir. This is why it is not god to have the head software engineer also the acting DBA and database developer. Hence, why my company put together a DBA team. Still trying to pry away some of that power though.

    Jared

    Jared
    CE - Microsoft

  • tell them its not preaching its fact!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (10/24/2011)


    jared-709193 (10/24/2011)


    Yes, their view definition included the TOP and ORDER BY

    don't know how many times it's been said but "Don't order by in a view" 🙂

    A view is essentially a table, all ordering should be done outside the view

    This is straight from Microsoft

    http://support.microsoft.com/kb/926292

    This is interesting because Microsoft is saying that this is a bug... Only in the TOP (100) PERCENT... They shouldn't treat this as a bug. Ugh...

    Jared

    Jared
    CE - Microsoft

  • A good video on the subject (clustering key): Kimberly Tripp - The Clustered Index Debate. One of a whole bunch of MCM Videos.



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply