Post reply

Index Sorting

  • June 6, 2007 at 10:00 am

    #176976

    In studying for 70-431, I came across an interesting item I hadn't seen before.  Apparently, you can sort indexes, even non-clustered ones, by column ASC and DESC. 

    Has this behavior existed previously (like SQL 2000) and I just didn't know about it?  Or is this a new thing?

    Example:  Create nonclustered Index IX_MyIndex on dbo.MyTable1 (Col1 ASC, Col2 DESC)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 6, 2007 at 10:57 am

    #711191

    Its been there.

  • June 6, 2007 at 12:13 pm

    #711206

    Wow.  All the times I did index creation and I never saw it. 

    Huh, the things you learn when you do a "start from scratch" cert studying experience. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 3 posts - 1 through 2 (of 2 total)

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