I had a similar thing happen. Web accessed database, took forever for customers to upload their data. I found out what the query was, created an index and voila! The boss said the same thing to me "What did you do?". Of course, I was the first one laid off because I wasn't as up on C# as the others......
I keep it simple. If they ask me to write C#, I remind them that I was looking for a job when I found this one. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.