Reputation
310
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 11
Impact
~5k people reached

  • 0 posts edited
  • 1 helpful flag
  • 26 votes cast
Feb
6
revised Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
Tidying up the formatting, making some clarifications
Jul
24
revised Difference between count(*) and count(1) in mysql?
Yup, my bad. DISTINCT definitely does evaluate the expression. And noted that for ALL expressions, they are still evaluated for NULL
Jul
12
revised Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
Clarify initial opening paragraph
Jul
31
revised Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
The index 'redundancy' was spotted after being inspired by Kimberley Tripp's blog article - referenced.