This won't give you the user, but some info may be stored in sysobjects.dbo.crdate

Two simple options:

1: use sp_who, and kill to kill processes that block your backup

The database will halt the processing of anything you kill.

2: perform backup in single user mode: EXEC...

this is probably caused by a large number of indexes.

I agree with everyone above.

You will probably need to create a cursor for what you are trying to do.

Try the following:

select * from employee e

inner join employeeDetails ed on e.[id]=ed.[id]

denormalized the dimension tables by functional group.

the fact table should contain mostly aggretable data, numbers/amounts.

Avoid using text in the fact tables.

Since this is from April, you should upload the templates you ended up using.