Its a dependency for non-schema bounded views.

Yes you need a installer (setup) file .

No, you can't rename the named instance.

BOL:

They can be used only to rename the part of the instance name that corresponds to the computer name. For example, you...

Here is good article on this.

http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/30059/

You can use below query to find out the current blocking transactions.

Select * from sys.sysprocesses where blocked<>0

If you are using Sql server 2005 or higher version then you can...

All your questions are covered in below link.

http://www.mssqltips.com/sql-server-tip-category/39/fragmentation-and-index-maintenance/

spid 318 is blocked by spid 611

Check this article

http://www.sqlservercentral.com/articles/Blocking/64474/

Here is a nice article on this.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

good examples.

Check this.

http://www.gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/

You Welcome:-)

Here is this.

http://www.mssqltips.com/sqlservertip/2070/sql-server-restart-validation-checklist/

Sql server 2008 R2 express edition thhe database size limitation has been increased to 10GB

http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

It seems a nw issue , please check below links for more details.

http://ask.sqlservercentral.com/questions/74014/urgent-help-required-the-semaphore-timeout-period-has-expired-sqlstate-08s01

http://sqlblog.com/blogs/merrill_aldrich/archive/2010/06/10/windows-server-2003-network-boogey-men-every-dba-should-know.aspx

analyze which Transact-SQL statements are the top consumers of tempdb

SELECT t1.session_id, t1.request_id, t1.task_alloc,

t1.task_dealloc, t2.sql_handle, t2.statement_start_offset,

t2.statement_end_offset, t2.plan_handle

FROM (Select session_id, request_id,

SUM(internal_objects_alloc_page_count) AS task_alloc,

...