a few points about sql server execution plan

• sql server will not use your order of joins if it thinks it can do it better. For example, if in your code a is joined to b and b to c but the index on a is enough to get the columns needed on c - it may join a to c.
• the only thing for certain is logical reads, not physical
• the determining factor for high % (for example , shown in sql sentry plan as red) is the amount of executions

Getting latest from Solution and getting latest from source control explorer are

different

ctr-r-t in tests in VS

runs that test alone

The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate'

in this case we were using wshttpbinding
this was happening with some kind of certificate issue. we changed the client service url to refer to the port and this issue stopped

Like in sql profiler

is not sql's like - its an exact match

Access to the path 'blah' is denied.

could be read only issues

Immediate Window - end of expression expected

Check for illegal charcters