I just came across the issue of building up a SQL Server 2005 on a standalone copy of Win2003 and then joining the box to a domain later if there will be any issues. A quick google search turns up ...

Understand the effects of NULLs on inner and outer JOINs Your email has been sent SQL Server developers must understand two things: the difference between inner and outer JOINs and the effect of NULLs ...

When you want to find all the objects that are missing a corresponding object, then you need the LINQ equivalent of an outer join. Here, step by painful step, is how to build that query. Here's a ...