If you are not sure about t-log you can also take differential bakcup and subsequent t-log backup and restore on the database.

Also check if any open transactions are running when tempdb is growing. Also check if data or log files are growing to narrowdown the issue.

What SQL Server version you are using? Check the feature "Always On" of SQL Server 2012 if using SQL 2012.

You can also do the same by exeucting Restore backup job. After that recover database.

Compare to Mirroring, always on will have more flexibility. I would prefer always on. e.g. multiple database, multiple secondary and much more.

Are you facing any resource issue? provide more detail.

Yes, it is always better to have seperate database which will result into easy maintenance of the database and easy to narrow down the issue you will have on specific...

check following link:

https://social.msdn.microsoft.com/forums/sqlserver/en-US/2c33ae5d-13bc-41cb-b301-d977897b6e89/uninstalling-sql-from-the-commandline

What is the analysis of your storage Admin? Usually read should not be high? Does it happen on all server using same SAN? If it is new server with no...

Agreed with Grant.

Refer following article to do further R&D.

http://blogs.msdn.com/b/psssql/archive/2015/03/06/does-rebuild-index-update-statistics.aspx

HTH

Were you able to connect earlier? Looks like DNS issue and work with network team to resolve the issue.

Check the following link which might help you. You can modify the same as per your requirement.

http://www.keepitsimpleandfast.com/2009/09/use-batches-to-delete-large-number-of.html

HTH

This is very broad sense. What exactly you would like to compare?

To start with comparing the output of two server in xls. You can execute sp_configure to get the detail...

Easy one, Thanks.

Make a simple test. Take stored procedure which is running slow after reboot of the server (or RESTORE) and execute quickly from the second execution onwards.

Simply recompile that stored procedure...