good for beginners.

http://www.sqlcourse.com/index.html

http://www.w3schools.com/sql/default.asp

use sp_execute to run dynamic commands.

Check this bog on this.

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

2 batch file is not required.create only one batch file with following command.

NET STOP SQLSERVERAGENT

NET STOP MSSQLSERVER

NET START MSSQLSERVER

NET START SQLSERVERAGENT

jyoti.patel (2/20/2012)

---

We would like to automate a way to restart SQL at 5:30AM local time every morning. We have an application that hangs until the SQL service is restarted. Cau...

check this link

http://sqlserverpedia.com/wiki/Best_Practices_for_Creating_Indexes

check this.

http://www.sqlservercentral.com/articles/Upgrade/65872/

What is the size of error log?

this may help you

http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/

check this article on PLE.

http://www.sqlskills.com/BLOGS/PAUL/post/Page-Life-Expectancy-isnt-what-you-think.aspx

When there is a failover happens sql services got recycled.

check this article.

http://www.sqlservercentral.com/articles/Transaction+Log/71415/

use pivot and unpivot feature of sqlserver.

http://msdn.microsoft.com/en-us/library/ms177410.aspx