Timeline for Sort order specified in primary key, yet sorting is executed on SELECT
Current License: CC BY-SA 3.0
11 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jun 17, 2012 at 1:35 | history | tweeted | twitter.com/#!/StackDBAs/status/214169240280895488 | ||
Jun 13, 2012 at 12:08 | vote | accept | m__ | ||
Jun 13, 2012 at 12:05 | history | edited | m__ | CC BY-SA 3.0 |
fixed query
|
Jun 13, 2012 at 8:10 | history | edited | m__ | CC BY-SA 3.0 |
added non-successfull cross apply solution
|
Jun 13, 2012 at 7:08 | history | migrated | from stackoverflow.com (revisions) | ||
Jun 13, 2012 at 6:41 | comment | added | m__ | OPTION MAXDOP 1 does not help. As specified by @Martin Smith below, it seems as the partitioning is what's causing it... | |
Jun 12, 2012 at 23:52 | answer | added | Martin Smith | timeline score: 13 | |
Jun 12, 2012 at 14:23 | answer | added | gbn | timeline score: 5 | |
Jun 12, 2012 at 14:04 | answer | added | Mike Sherrill 'Cat Recall' | timeline score: 9 | |
Jun 12, 2012 at 8:28 | answer | added | Fergus Bown | timeline score: 1 | |
Jun 12, 2012 at 8:06 | history | asked | m__ | CC BY-SA 3.0 |