305 reputation
210
bio website dvt.co.za
location South Africa
age 43
visits member for 2 years, 3 months
seen Apr 3 at 3:40

I have been developing software of all shapes and sizes using Microsoft technologies for around 20 years now.

The wonder of our profession is no matter how much experience we have, is that we continue to learn something new every day.


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.