Performance differences aren't the reason to chose one over the other. Purpose is the defining characteristic that separates procs from triggers.

Do you have a specific issue that you're trying...

Bob Hovious (2/10/2009)

---

This is why I think interview questions should just go unanswered, even deleted. There's no telling how much damage is done to companies that are...

Create a query that selects the company IDs/names/whatever that you want files for. The idea is one row per file to be created.

Use that in SSIS to create a...

Kit G (2/10/2009)

---

I understand. Makes you think you've accomplished something! 😀 At least I did...

Is it running into a deadlock?

Books Online and http://www.msdn.com have data on how to use DDL triggers to audit database changes. Look them up in there, you'll get what you need.

There's another parameter that might help, @query_result_separator. It's char(1), and defaults to a single space. If you change that, it might help.

Default trace will have some of that.

If you want more, you pretty much need to set up DDL triggers and log the changes. That's pretty easy to do.

The difference is that reorganizing an index just defragments the index, while rebuilding the index creates a fresh copy of it, and updating the statistics gives SQL Server an idea...

SQL Server translates "between" into the other at runtime. No difference except possibly readability.

Clever solution. I like it. Quite elegant. And the usual argument about the uselessness of the Pivot command is bypassed by having the columns be the Row_Number...

I think the question was clear enough. But Hugo is right about the variations on the definition of "best".

You could use a series of Case statements.

select

case

when Val1 >= Val2 and Val1 >= Val3 and Val1 >= Val4 and Val1 >= Val5 then Val1

when Val2...

On the point of "no problem" vs "you're welcome" vs "sure". Any response that expresses acceptance of the "thank you" and validates the gratitude works. In Spanish, a...

Glad we could help.