Blog – Page 2 – Anshul Dixit

7 Tips to Optimize SQL Queries

January 7, 2022May 28, 2016 by Anshul Dixit

Have you ever stared at your computer screen wondering why it is taking so long for your SQL query to run? You are not alone in this universe, we all have been through such situations quite often. Of those, a few have been lucky to get help from their colleagues and seniors in understanding the … Read more

Why Exit Polls Lie?

January 7, 2022May 20, 2016 by Anshul Dixit

Yesterday (19th May 2016) assembly election results for 4 states in India were announced. In Tamil Nadu, Jayalalithaa’s party AIADMK proved the exit polls wrong by coming to power second term in a row. This is not a first, various elections in the past have revealed the inaccuracies in the exit polls. Who can forget … Read more

How Vistara Lost Loyalty of a Customer

January 7, 2022October 30, 2015 by Anshul Dixit

Vistara, a Hindi word which means ‘expansion’, is also the name of an Indian airline operated by Tata Sons & Singapore Airlines. It commenced operations on 9 January 2015 in India. 7 months later, on 9th Jul, 2015 I boarded an Air Vistara flight for the first time. So impressed I was with the service … Read more

WHERE Clause Conditions with OUTER Joins

January 7, 2022July 28, 2015 by Anshul Dixit

SQL Error One common mistake that people make while writing Outer Joins is incorrectly specifying a condition in the query. It’s such an innocent mistake that unless you have an idea of the expected result you won’t even realize that you made a mistake.

4 Lessons I Learned At Facebook

January 7, 2022July 4, 2015 by Anshul Dixit

1st Jul, 2015 was my last day at Facebook. Over the period of 4 years that I spent at Facebook, I learned a lot, mainly: It’s OK to make mistakes. It’s OK to fall on your face and rise again. To the new leads and managers out there, give your team the confidence that you … Read more