>Is there any possibility of doing actions that will improve the performance on writes? I understand the writing procedure from SQL Server would take more time than regular SQL select and that indexes are a factor, but if there is something I am missing, I would like to know about it.

The question is too general. What exactly do you mean here and how do you write?