not in and not exists

here

WCF - The message could not be dispatched because the service at the endpoint address … is unavailable for the protocol of the address

here

change sql profiler defaults

here

Trying to pass a table-valued parameter with 11 column(s) where the corresponding user-defined table type requires 12 column(s).

select tt.name,count( c.name) from sys.table_types tt
inner join sys.columns c on c.object_id = tt.type_table_object_id
group by tt.name

sql server profiler woes

i couldnt see anything with sp - stmt start - i only saw with rpc completed

http 404 error on wcf rest service httpget

i was getting because of the length of the querystring

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

just means a timeout