Triggers, in my experience, are best used sparingly and with careful forethought. Triggers that reference other database objects add complexity to query plans.

I worked on a system (in DB2) that...

I think this difference in behavior may have something to do with the fact that the construction we're all so used to in SQL Server

SELECT (some thing or expression)

is...

This is one of the best articles I have read in a long time. Excellent work.

I called mine the 'Integers' table. Because it's a table of INTs. Also, I used to write code for the lumber industry, where 'Tally' has a specific meaning.

I think I'm with Tony Scott on this one: why not prevent the issue at insert time, rather than go through all the pain of removing duplicates after the fact?

rbramhall (10/28/2009)

---

The problem is that whenever I update the product mix, I'm deleting/updating/inserting up to 2.5M rows in the 83M row table at a time. We threw lots of hardware...

Great article. It discusses index stats in just enough detail to make things clear without bogging down.

It would be interesting to do some testing to see at what point the cost of the recomplications outweighs the overhead of #temp tables.

I'm taking Kalen Delaney's course in two...

Damn good article. I knew that table variables didn't have stats computed for them, but I hadn't fully considered the implications of that.

One point which your article doesn't make explicitly...

michael ham (3/8/2009)

---

we have a stored procedure that is periodically causing performance issues. When the procedure is flagged for recompile, it takes 3 - 4 minutes to compile. ...

Well, I feel a bit better. I spent a lot of time digging and couldn't find anything. I'll post the same question on usenet and see if any of the...

GilaMonster (3/8/2009)

---

😎 May I...

musheik (3/8/2009)

---

Thanks you all, for your valuable suggestions. i am concluding that with sql server we will be slower than Oracle,And we cant do much modifications with sql server...

Of course. I should have thought of that. Thanks.

Phil Factor (12/12/2008)

---

You sit down at the keyboard and you say to yourself, How in the blazes am I going to test this routine I haven't yet written? Once...