305 reputation
211
bio website dvt.co.za
location South Africa
age 44
visits member for 2 years, 11 months
seen Dec 15 at 18:53

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, and that to teach IS to learn.

Current obsession : Having a chuckle at local South African culture (or lack thereof)


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.