I fixed my problem by updating the statistics of the table indexes (as stated by 'GilaMonster').

Thanks to ALL

JP

Yep, was looking into it.

Think it SOLVED my problem. Will continue checking and will confirm later on, but speed definitely improved drastically.

Thanks Again

JP

There is definitely more data as it is a subset, but it takes MUCH more time to pull the Subset data.

Thanks

Although it's not exactly what I needed, I found the Function Is_SrvRoleMember('SysAdmin') from it's help page.

JP