query preformance

Welcome to the forums!
About the question (about 2005 in 2008 section):
Think.

[quote user="test"]
Hi All,
I am using SQLServer 2005.
my SQLServer system ram is 2 GB.
It is taking time to insert even 1 record .
what to do ?
[/quote]
Can you please provide more information? Such as the table schema, the query you're using and what exactly it means when you say "taking time"?

Frank, Dinesh and Preethi, the guy name is "test" and, after 26 days, is not a real question.

My reply was 2 days after the question... []

<p>[quote user="FrankKalis"]</p><p>My reply was 2 days after the question... <img src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif" alt="Smile"><br></p><p>[/quote]&nbsp;</p><p>You are the sunshine of my life..lalalalala[] <br></p>

Don't worry. Happens to me as well that I don't look at the post date.

[quote user="preethi"]
[quote user="Luis Martin"] Frank, Dinesh and Preethi, the guy name is "test" and, after 26 days, is not a real question.[/quote]
hmmm...I need to learn more things regarding posts. Thank you for the feedback.
.[/quote]
I try to wrote something funny and, because my lack of English, all of you take it seriously. Sorry about that.[:$]

Memory is not the only issue when it comes to performance. There are many things you need to look at.
is it happening every time or at specific time.
Can you share us the insert script you are trying to execute