189 reputation
213
bio website gfk.com
location United Kingdom
age 37
visits member for 2 years, 2 months
seen Sep 25 at 14:18

Web Operations and database administration


Dec
16
awarded  Notable Question
Sep
11
comment Using TOP and getting different result sets
Sorry, yes, missing some important info. Can't really post full table definition. OrderID is an IDENTITY column. A clustered index on OrderID.
Sep
11
accepted Using TOP and getting different result sets
Sep
11
comment Using TOP and getting different result sets
I think the most efficient method for me will be to add and ORDER BY OrderID clause. Michael Swart is approaching this in a very similar manner to me, which is reassuring.
Sep
11
comment Using TOP and getting different result sets
Thank you Aaron. This is fascinating. I see now my incorrect assumption that having orderID as primary key and clustered index, although it will physically order the data in a table, will not provide reliably ordered retrieval.
Sep
10
asked Using TOP and getting different result sets
Aug
23
awarded  Popular Question
Aug
8
awarded  Popular Question
Aug
4
awarded  Notable Question
Jul
30
accepted Restarting a Publisher involved in Merge replication
Jul
29
asked Restarting a Publisher involved in Merge replication
Jul
2
awarded  Curious
May
4
awarded  Popular Question
Mar
20
comment Running MongoDB and SQL Server on the same host- memory pressure
Max memory is default.
Mar
20
comment Running MongoDB and SQL Server on the same host- memory pressure
Edit: included additional facts and figures.
Mar
20
revised Running MongoDB and SQL Server on the same host- memory pressure
added 202 characters in body
Mar
20
asked Running MongoDB and SQL Server on the same host- memory pressure
Oct
31
asked Approaches for Real time copy of database on same SQL Server instance
Sep
23
awarded  Informed
Sep
23
comment Excessive replication snapshot size causing failure
Thanks Kin, Kendal Van Dyke's approach is interesting.