I ran into this issue today and it’s the second time this has burned me. It didn’t take as long to figure out this time, but hopefully typing this up will ingrain it into my brain further.

Today I was generating a typed DataSet, using the Data Source Configuration Wizard in Visual Studio (“Add New Data Source…” from the Data Sources window or Data menu). I had two stored procedures, accessing a linked server, in my database that I wanted added to my DataSet.

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.