Stefan Krzywicki (9/13/2010)

---

My apologies for this, but something occurred to me this morning and this was the only place I could think to tell people that would understand.

I was thinking...

This should work:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))

BEGIN

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id =...

I suggest that you:

1) Post your table scripts, as described in the article linked in my signature line

2) Post your sample data in a more consumable format (INSERT INTO script)

3)...

Lowell (9/10/2010)

---

because of the error "A triggermust be the first command in a batch"

you have to use dynamic SQL after the IF EXISTS test.

that goes the same for procedure/ function/...

Because some statements have to be come first in a batch. Create trigger is one of them.

You could use dynamic sql:

IF someCondition

BEGIN

EXEC('CREATE TRIGGER ....')

END

Try rebuilding your clustered index on the table, that should help.

DMVs could give you a starting point.

Look up sy.dm_missing_index_* in BOL.

Hope this helps

Gianluca

Install one. It's quite easy, even for a poor noob like me.

I got Sun VirtualBox...

Don't know. What do bookmakers think? 😛

I think you'd better start a new thread for this question.

Unfortunately that's a very little information to work on, I don't think I can help you.

Thank you, Paul. This is one of the topics I always wanted to investigate deeper, but never did.

I look forward to reading the next parts.

I will try to avoid...

Steve Jones - Editor (9/3/2010)

---

Isn't it happy hour for you, Gianluca?

Relax, ultimately you want to be professional, but it's a job. Give you opinion, document, go with the crowd if...

Well, our argument went a bit far from where it...

Yesterday I had a wild argument with my boss, claiming that a column named "description" could be perfectly suitable for a foreign key.

I had to leave the office and go...