iam working in web application and i have performance problems iam using ASP.NET 2.0 and SQL SERVER 2005
i know that the problem root is sql can any one provide me a good way for sql writting and connecting to server smoothly
*i tried stored procedures but not solve
thanks