They need to 'see' the jobs and be able to run them. We are using integrated security.

I got into a solution that is working, but its a workaround, I've joined...

Ater creating the new non clustered index I got improvements when the query returns a small result set.

After looking at the execution plan it was possible to determine that when...

Sorry PW, you're right it was a 'Cluster Index Scan' ( I'm rewinding it in my head I'm not at work now )

I suppose the index seek would perform faster than the...

The execution plan shows that 88% of the time is spent in the index seek.

What should be the best index solution? One for each column (f3, f4), or just one...