Most, if not all of that you should be able to get from sys.dm_exec_sessions, sys.dm_exec_requests and/or sys.dm_os_waiting_tasks.

Have a go through those DMVs, if you can't get something as you want...

Why are you thinking about creating an indexed view?

jasona.work (9/16/2013)

Right up until I aim...

What is the exact command you're using to back up the log?

If you were getting an error saying that nulls are not allowed, then there were nulls in the select for that column.

Post the exact code, we can't tell what's wrong...

Maybe start by reading the whitepaper linked here: http://sqlblog.com/blogs/kalen_delaney/archive/2013/06/05/hekaton-whitepaper.aspx

You've got a small row count, so differences in time probably won't be noticable and if you look at the examples in the blog posts, you'll see that mostly the...

Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

You can query the sys.columns metadata view to see what tables have particular columns in them.

Not physical IOs, just IO usage. More IO usage, more chance that some will be physical. If you're tuning IO, tune logical IOs, if less data is needed overall, less...

You don't need a case statement here.

Take the query you posted, figure out how to have that query only return salary values that match the requirement.

Please run the following and post the full and complete, unedited output

DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

You can also point out to the vendor who recommended that, that rebuilding...

If you need a particular order by on a set of rows, then you need an order by statement on the outer-most select. This isn't about order of subqueries executed,...

First things first, take that query you already have and figure out how to have it only return rows for salary under a specific value (which from the reading I...

I'm not going to do your homework for you. You learn nothing, I don't need the practice and I'm sure your lecturer doesn't condone other people doing your work for...