Check this out:

http://stackoverflow.com/questions/15375218/how-to-convert-columns-data-in-comma-separated-list

HTH

Attach execution plan too which will be easy to help you.

Ask your system admin to create a 'Task Scheduler' to begin this task at start up.

It is OK if you use this On the test/dev environment but suggested not to use it On PROD server.

I guess you can achieve this through IF..ELSE and WHERE clause.

HTH

What do you mean by tempdb clean up? Usually SP use tempdb for temporary calcuation and you need to fine tune stored proc which help to improve performance.

HTH

Enjoyed the question, thanks.

What is the status on serverA sync with ServerB? Not sure how is your database on serverA? Refer following link which might help you.

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

HTH

If everything going fine do not worry. This is because of maintenance task. And I guess it happens after reindex?

HTH

It all depends on the application. I suggest to refer best practice naming convention and prepare the document. Also circulate the same to the development team before you proceed further.

HTH

It's all depends on DB size and application. Also you can have benchmark if your current application is running on other server.

However as rule of thumb log size is...

How about SSRS?

It will do much more than you think. Please refer SSIS in BOL for further detail.

You can also think about database import which also support Access source.

Refer following links which...

SQLServerCentral is best option according to me. This is due to two things one is limitation of 140 character and another many might not help you as twitter is filtered...

Check out the possibilities with SSIS.

HTH