168 reputation
28
bio website heliosphan.org
location England, United Kingdom
age
visits member for 2 years, 11 months
seen Dec 11 at 10:28

Jul
28
awarded  Notable Question
Mar
27
awarded  Popular Question
Apr
8
awarded  Popular Question
Oct
31
accepted Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?
Oct
23
comment Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?
There's a good reason for asking as the order-by clause in question is very complex and therefore copying creates both code maintenance ballast as well as increasing the probability of future defects. The other alternative is a minor refactoring which I thought I might be able to avoid if the SQL standard defined an implicit sort order. In any case I was just interested if there was formal documentation covering this point.
Oct
23
awarded  Custodian
Oct
23
reviewed Approve Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?
Oct
23
comment Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?
OK I'll add one further qualification - are the results guaranteed to be sorted if only one ROW_NUMBER() clause is specified.
Oct
23
asked Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?
Sep
19
awarded  Notable Question
Mar
19
awarded  Popular Question
Jan
13
revised Why are breakpoints not being hit in SQL Server Management Studio?
Additional info.
Jan
13
asked Why are breakpoints not being hit in SQL Server Management Studio?
Jan
10
awarded  Editor
Jan
10
revised Auto Update Statistics in SQL Server 2008R2: Why do some statistics remain stale despite a large number of row inserts?
added 715 characters in body
Jan
9
awarded  Supporter
Jan
9
awarded  Student
Jan
9
awarded  Scholar
Jun
16
asked Auto Update Statistics in SQL Server 2008R2: Why do some statistics remain stale despite a large number of row inserts?