I had a talk with the most silent person in our team...
I just had a talk with one of our senior .Net developers. I asked him if he know about Execution Plan and Indexing in Database. Hmmm... I was shown a diagram in SQLServer which apparently computes the cost of each query in percentage. I guess query optimization is just left with the programmer of the query after all. He also showed me how to create an Index. I learned that it makes searching faster on large records but has has a drawback of being slow if the table is being frequently updated(like something is being inserted every time).
I also got a bonus lecture on Cursors and Triggers. It's funny how I related to cursors to java.sql.ResultSet. Triggers to the Observer pattern as you set a trigger to a table and fire up a message to other tables if an update is made to the table where you set the trigger.
Wow, I think I just saved myself a few months or years of having to learn all these stuff. Of course, application of these knowledge will have to wait until I get into a project where I could utilize them. My heart feels so happy right now. :) I could burst down in tears!
Thanks to this Mr. MCAD, MCSD and the list goes on for his certifications. He is one M$ certification freak!