Post reply

Order by Increases the number of records returned

  • January 19, 2005 at 3:33 am

    #87787

    Now here's a strange one. Order by Increases the number of records returned. If I run my query without an order by or with an order by on a different column from the requied field then the correct no of rows (33) are returned. If I use the required order by (Datatime field) then I get 137,000 rows. I assumed there was an index corruption and ran dbcc dbreindex on the indexes on table then updated stats. But this didn't fix the problem. However if I use an index hint for the index this datetime field is in, then it returns correctly. I'm still worried and wonder if my whole db has somehow been corrupted. Anyone come across anything like this.

  • January 19, 2005 at 4:18 am

    #538011

    Have you run a dbcc checktable to check for possible errors?


    Shamless self promotion - read my blog http://sirsql.net

  • January 19, 2005 at 5:40 am

    #538028

    What was your query?

  • January 19, 2005 at 8:08 am

    #538081

    I'd do a backup for sure and then get a checkdb running. If there are any errors, call PSS.

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

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