305 reputation
211
bio website dvt.co.za
location South Africa
age 44
visits member for 2 years, 9 months
seen yesterday

I've been developing software of all shapes and sizes using Microsoft technologies for over 20 years now.

The wonder of our profession is that we continue to learn something new every day.

Current obsession : Simple Math Fraction Calculators for my kid's school maths (and prime number generation for Project Euler ;-)


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.