SQLServerPedia

Bryan Oliver says:   We here at SQLServerPedia have received quite a few questions related to the creation/implementation of database objects such as Triggers and Indexes. I would like to provide a short list of articles and postings related to these DBO’s, their creation and their useage. If you’re a beginner and not very familiar (or even if you just want to brush up) please take some time to check these out – they helped me!

Thanks!

Here is some articles on triggers.

http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server  

http://www.sql-server-performance.com/nn_triggers.asp  

http://www.codeproject.com/database/SquaredRomis.asp  

And some articles on indexes

http://www.odetocode.com/Articles/70.aspx  

http://www.sql-server-performance.com/optimizing_indexes.asp  

http://www.devx.com/getHelpOn/Article/10016