Oh thamk you. Thank you. Thank you.

Even if I head read a thousand pages, I would never have gotten the "true" reason. This is exactly I needed.

I moticed you...

This is great information ( even more than I ever expected to get ). But I still would like to know if there is a book/site explaining the "suttle" differences...

I have worked in shops where ther have been dbas, security admins, operators, network specialists, etc. My role there was that of an application developer. This situation is different though....

Thank you for confirming that. I was getting worried about doing something terribly wrong. By the way, what if FWIW?

Thanks a ton Wingenious. This is exactly what I was looking for. Would you also recommend a good book/on-line resource along this line for more in-depth and intermediate/advanced studies.

I will...

good point. i for sure don't want to be the security administrator.

When you define a new table, and you define a PK, aren't you already creating one index? You then can create more indexes on FK and any other column you...

I don't know how to use the Execution Plan. But looks to me that it could be very valuable. I'll have to make sure that I understand it well.

Thanks. It worked. Is there any difference between a JOIN and an INNER JOIN?