To delete data through a view example.

http://technet.microsoft.com/en-us/library/ms189835.aspx

Here is the steps to change the password.

http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/

Check this article:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx

Its better to anlyze it through Query execution plan.

http://www.sql-server-performance.com/2006/query-execution-plan-analysis/

This may help you.

http://www.mssqltips.com/sqlservertip/1880/install-sql-server-reporting-services-32-bit-on-a-64-bit-windows-server/

Please post the full error message.

Please check below link for same issue.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64473

Check the status column of that corresponding session. and it will provide you the what currently that session is doing.

You can find backup failure errors in SQL server error log as well.

Similar post.

http://www.sqlservercentral.com/Forums/Topic1079609-146-1.aspx

Check this article.

http://siddhumehta.blogspot.in/2009/04/sql-server-proxy-accounts-feature-use.html

Please post full error message of login failure as error message 18456 has states which indicates the exact problem .

Check this.

http://www.sqlservercentral.com/Forums/Topic853077-391-1.aspx#bm892257

Nice article on performance with multiple filegroup.

http://www.sql-server-performance.com/articles/per/optimize_filegroup_performance_p1.aspx

Use prformance counter like PLE ('Page life expectancy'), buffer cache hit ratio to find out the memory contegency. capture the data during various time of the day like peak and...