Are you planning on basing your software purchasing decisions on the results? If not, why are you doing this?

I can't quite work out what's going on here.

It sounds like all of your data is coming from text files and SQL Server is not involved at all. Is that...

I work from home and use a single 49" Samsung gaming monitor, which I (virtually) split into three windows. Having got used to it, I would never choose to go...

I get this error an estimated 90% of the time. I know now to simply...

If you search other forums, you will see that this is commonly known as the 'silent truncation issue'. The most common workarounds appear to be as follows:

1. Do your length...

Interesting.

It would appear that the second and subsequent executions of declare @spec are completely ignored.

As there is no way (as far as I know) of destroying or amending a table...

Simply reading from a table that is being written to should not cause a deadlock. Are you sure that the read queries are causing the deadlocks?

Experts, I am learning some skills so I can troubleshoot some performance-related issues. I have gotten good with some basics but when it comes to query which gets the...

Run the tasks in series?

Use project-level connection managers, and then the change is required in one place per target.

Unless the number of tables containing defaults is likely to keep changing, I...

Argh - yes. But how could you ensure that the value for DefaultPK in a given row existed in the table referenced by TableName? My 3NF-violating approach did allow...

And we can obviously manage more than one "table needing a default row" in the new table - one column per such table.

Does anybody know of any drawbacks with...

Are you saying that my code does not work this way?

I've done the emails, the phone numbers and unmatched in the code that follows. You can add the rest yourself.

--Rule 1 - E-mail match
WITH AllEmails
AS (SELECT c.Custno
...