It's 1 point per post, correctly answered Questions of the Day at their point value (usually 1-2 points).

We may expand it to scripts and articles, not sure yet.

It's kind of...

Very interesting comments and thanks for the debate.

If the company doesn't ask about some skills or change the reason they hired you, then I think it's fair that you wouldn't...

I tend to agree with Sharon. Anyone other than an expert, meaning someone that has more experience and success than at least 75% of the people in the field is...

Glad to help and let us know if you figure something else out. Might help the next DBA.

Steve

This doesn't make sense.

Can you separate columns and data, or is that not what you're showing.

You have an incomplete SQL statement that includes stuff that doesn't seem to relate to...

I'm not sure what you mean here. Import into test before test?

If you are trying to drive a job with a loop, I'd make a table in some db, maybe...

I'd do what Phillip suggested and also you might want to ensure there are limits to how tempdb can grow. If you allow autogrow, you might set a "space holder"...

Same file in both cases? Same collation?

Are these the same server or at least same version/localization of Windows?

Can you post the exact error?

How are you importing?

Two different jobs, even with the same user calling them, in this case SQLAgent, should have different SPIDs. The SPID is the process handle for the connection. Name of user...

That's the way to do it. For regular operations (add, edit, delete) or objects, you don't want to mess with the system tables as a rule. There are exceptions, but...

What's incorrect?

If the first column is a key then you shouldn't have duplicates.

You could qualify Andras' solution by first only grabbing dups.

select t1.key, t1.name, t2.name

from (...

I've seen similar issues and struggled with them. For some reason the query optimizer runs things differently in a proc at times.

If possible, it helps to try and clear the...

I completely understand, but please post some specs when you decide. It would be helpful for others. Also, can you post the current server specs.

Colin will have great advice, but...

Markus,

Very interesting. What was the issue with the view? Was this hotfix'ed?

Can you explain what you are trying to do? Any reason you can't do the math inline with your other queries/operations?