Reputation
335
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 13
Impact
~14k people reached

  • 0 posts edited
  • 0 helpful flags
  • 28 votes cast
Oct
28
awarded  Nice Question
Sep
29
awarded  Nice Question
Jul
27
awarded  Caucus
Feb
21
awarded  Popular Question
Feb
16
awarded  Nice Answer
Oct
10
awarded  Popular Question
Sep
24
awarded  Autobiographer
Aug
12
awarded  Necromancer
Jun
19
comment What is the best way to get a random ordering?
Sure, auto-magic is nice. In practice, I've rarely seen a 5 row table scale to millions of rows without notice. TABLESAMPLE() seems to base selection of the number of pages in a table, so the given row size influences what comes back. The point of table sample, at least as I see it, is to give you a good sub-set from which you can select -- kind of like a derived table.
Oct
2
comment What is the best way to get a random ordering?
@db2 -- Sure, and easy enough to add. I've just haven't seen much discussion of the feature...it's one of those hidden gems in SQL Server.
Oct
2
awarded  Yearling
Oct
2
answered What is the best way to get a random ordering?
Oct
27
comment Design Pattern - One of Many Parent Tables
@NathanLong - I've never come across a formal name for this pattern. Octopus isn't bad. I've also thought of it as a one-OF-many join.
Oct
17
awarded  Commentator
Oct
16
accepted What factors go into an Indexed View's Clustered Index being selected?
Oct
15
revised What factors go into an Indexed View's Clustered Index being selected?
typo in title
Oct
15
asked What factors go into an Indexed View's Clustered Index being selected?
Sep
29
comment Rules in SQL Server 2005
Just an FYI .... RULES have been marked deprecated in SQL 2005 & later. They exists, but you are cautioned against using them in new development work. msdn.microsoft.com/en-us/library/ms188064%28v=sql.90%29.aspx
Sep
28
awarded  Teacher
Sep
28
answered For a boolean settings table, should I toggle a flag, or insert/delete?