When it comes to writing T-SQL, one of my pet hates is the unnecessary use of loops and cursors. As we all know, SQL is a set based language and has been designed to work using sets of data. Far too often do I see people looping unnecessarily in their back-end code resulting in a slow user interface.