I need more than luck. It is a 24/7 db with sometime during week without peak usage. My best understanding of with the clustered index is they tell...

most of the queries do links with these guids

Duh!!!!!

Thanks for showing my lack of ability to find the easy solution.

thanks that worked

Browser started, still will not work

thanks this worked, Should have thought about the left outer joins

Order table

orderid shipto locationid

1 acf fcd

2 ...

No actually join to one other table based upon columns in the first table. If shipto is null use location, if shipto has a value use that and ignore...

Found answer just as bizarre. Added my login (which is an admin on the box before this started) to sql logins made sysadmin and now steps show.

There are functions to do most all of this in SSIS

domain admin

The sql server is running under the same account for all our sql servers, never changed

Luckily I have been having RAID and hard drive issues to go along with this

both indexed

For the drive with the mdf I am getting about .016