Tuesday, April 28, 2015

file schema could not be identified because of an i/o error

i got this trying to read a _Traces.svclog with too many viewers open - wierd

Wednesday, March 25, 2015

top variable needs parentheses

declare @int int = 10

select top (@int) * from

bozo

more things done to improve sql

if force order hint is used - put left joins after inner joins
create indicies on temp tables after inserts

Tuesday, March 24, 2015

Tuesday, March 17, 2015

Monday, March 9, 2015

to avoid distributed transaction errors during debugging

on the callee comment out :

/*[OperationBehavior(TransactionScopeRequired = true,
TransactionAutoComplete = true)]*/