Good article. One thing that often crops up in job advertisements is "must have experience of the finance industry" and a premium is usually paid for candidates who have that...

When my brother was at college, he was astonished by his friend's reaction to the statement "I'm just going for a tommy". Both parties understood this to be rhyming slang;...

The answer "I don't know" was 100% correct in my case (of course, it's not now).

I've worked for managers who were useless in their current role, but brilliant if you needed them to answer technical questions. I've also worked for excellent managers who took far...

I realise this is an old thread, but I've stopped receiving the newsletter. It was getting increasingly sporadic over the last few months, but I've not received any at all...

To answer the original question; this

http://www.sqlservercentral.com/Forums/Topic1752249-1292-1.aspx

is recursion.

It looks as if only one connection is being used. When does the error occur; on table creation, row insert or the select?

I don't think anyone "builds his business on millions of lines of code". What happens is that systems get written and then things change (the changes are frequently made by...

Does that mean I get a toaster now?

We're probably going to be getting the Redgate tools fairly soon, so the developers will start using SQL Prompt. One of the things I need to do is set the...

Yes, we've noticed that it frequently puts superfluous brackets around the default expression in the script so that the resulting constraint in the database doesn't match the project and gets...

No apology required; it's always worth understanding what the tools are doing for us. As noted in a previous post, the problem I have is also occurring outside SSDT, so...

There is no trigger that would prevent this change. Another constraint change to the same table worked fine.

It's not SSDT after all. As suggested, I tried copying the DROP and CREATE statements from the deployment script into an SSMS window and ran them there. No errors, but...

If your problem is with joins or comparisons between columns in the temp tables and those in your database, you can specify which collation to use at that point, eg.

Select...