Introduction

Prevention is always better than cure is what I believe. It's a good idea to have a look at some safeguards so that common mistakes don't happen in the TSQL we write, which can cause performance issues later on. There are so many things to consider, to avoid common programming mistakes. Here, we are going to present few of them from the performance point of view.