This isn't something I've set up in my Availability Group work so far, but here's a blog post where someone ran into a similar issue.

You're still attempting to stuff multiple files into a single location. You can't do that this:

MOVE N'TELE_1_Log' TO

N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVERMSSQL\DATA\TELE_log.ldf',

Needs to be changed to something else, maybe...

These questions really sound like either an interview or homework. If I answer the questions, do I get the pay or the grade?

Itzik Ben Gan has a number of examples on how to find islands and gaps in sets of numbers in his book Inside T-SQL Querying. I'd suggest picking up a...

This is administrator information. Either you need to get view server state permissions or you need to work with someone who does.

I've mostly used SQL and it works great on 2012. You can even use the Availability Groups to do log backups or COPY_ONLY backups in addition to the normal backup...

That number does seem high, but only because I've primarily worked on systems with stored procedures. If you're working with lots of dynamic or ad hoc SQL, then that number...

Also, if the NOLOCK hint is applied to any kind of data modification queries, SQL Server just ignores it. It has to do locks in order to modify data.

I'll try. I might be...

Oops. Missed the missing 'IO' & responded too quickly.

You might want to take a look at Central Management Servers. It's a way to control & report back on multiple servers from a single location. Here's the BOL entry:...

User the value here, request_owner_id , to look at sys.dm_exec_requests. From there you can join to sys.dm_exec_sql_text or whatever else you need to understand what's happening with that lock.

Normally, I completely prefer a side-by-side upgrade. Get 2012 on a different server then move things to it. I find it to be a much safer and more consistent operation....

You're experiencing I/O waits during I/O operations... The only way to speed that up is to get faster/more disks.

I've been very happy (mostly) with my Toshiba tablet. But if the Surface comes out at $199, and it's a good form factor, plenty of memory, I think I'll upgrade...