>Index your Employee_Queue_Schedules by iActive_Flag and see if this speed this SELECT up. I hope you have index by cTrans_Employees_Queues_fk in Employee_Queue_Schedules.
I don't want to add an index on this integer field which has only 1 and 0 values.
We have indexes on every fk and pk.
If it's not broken, fix it until it is.
My Blog 
