SQL Optimization Case Study - JOIN Clause vs. IN Clause

SQL Optimization Case Study - JOIN Clause vs. IN Clause:

'via Blog this'

A Study of XPath Performance in .NET Programming

A Study of XPath Performance in .NET Programming:

'via Blog this'

very inspiring article...however in my case, if I get it of xmldocument all together (actually it is DataTable.select inside the xmldatadocument), the overall time it takes to finish project revaluation decreased from 30min to 12min!

The HTTP request is unauthorized with client authentication scheme 'Anonymou s'. The authentication header received from the server was 'NTLM'.

when testing a wcf web service, this error appears while it was working without any issue.
I had been searching for the answer for quite a while and none of them seems to fix my issue.
After reviewing my settings carefully, it appears that another settings in web.config is causing the problem. After I removed the section everything seems to be working again~

GIS and SQL Server 2008: Making Maps with your Data

GIS and SQL Server 2008: Making Maps with your Data

Are You a Control Freak? | BNET

Are You a Control Freak? | BNET

The adapter "Windows SharePoint Services" raised an error message. Details "The underlying connection was closed: An unexpected error occurred on a send.".

- anyone knows? trying to work out the cause at the moment

The adapter "Windows SharePoint Services" raised an error message. Details "The underlying connection was closed: An unexpected error occurred on a send.".

WMI Provider Error - Access Denied - TDSSNIClient initialization failed with error 0x5

WMI Provider Error - Access Denied - TDSSNIClient initialization failed with error 0x5