Month: September 2019

Supporting the LGBTQ #SQLFamily

September 23, 2019 Andy 0

I won’t be at PASS Summit this year, so unlike last year, I won’t be organizing an LGBTQ Meetup at PASS Summit. I’m hoping that even without the meetup, all my LGBTQ #SQLFamily friends will still get together for some fun and networking. Keep scrolling … [Read More]

Monetary value in integer over decimal datatype

September 15, 2019 Andy 0

Question I have came across several articles that mentioned that advise on not to store monetary value as decimal, but use integer instead. The reasoning that it does not store actual value and will cause some rounding difference/errors. But i have yet ever participate in … [Read More]

When to put a non-clustered index on your clustering key

September 3, 2019 Andy 1

There is a corner case where it makes sense to have a non-clustered index “duplicating” the clustered index. If you have a query that frequently scans the table, and ONLY makes use of the clustering key column, the query optimizer will prefer to use the non-clustered index.