Surely the update statements need to include a where clause condition referencing the inserted table. You only want to update the rows that triggered the trigger.

MARS? Multiple Active Result Sets.

Robert Frasca (5/7/2010)

---

Now that I've looked more carefully, the rows are a little over a 1,000 bytes each, most of that in one varchar(1000) field so it probably covers three...

Since you're on SQL 2005, rather use the 2005 DMVs - sys.dm_exec_requests, sys.dm_exec_sessions and sys.dm_exec_sql_text. You can do it as one query. Also, have you looked at sys.dm_os_wait_stats?

23 rows... How big are the rows? If all 23 will fit on a single page, then you're right, there's no point.

Have you tried the divide and conquer? Insert results...

Here's the Oracle-SQL conversion problem. Maybe stay out for now, we're getting nowhere fast and I don't think adding more people nagging for table defs is going to help.

http://www.sqlservercentral.com/Forums/Topic915299-145-1.aspx (Warning....

That is huge. No way I can do a full analysis of that.

One thing that may be worth trying... There's one place where the estimated and actual rows are differnt,...

b.noof (5/5/2010)

---

In Oracle it's a structure

but after i migrate from oracle to sqlserver it come a like u see it

i do the migrate with swiss its a soft...

No. It's a real table. A table variable would be prefixed with an @ sign. This table isn't.

No. Thesis is due end of the...

http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

I've added it to my 'list of topics to blog on'. Thanks, the list was getting a little short now that I've finished with in, exists and joins.

It's well over a year ago, possibly longer. In summary...

He...

Lynn Pettis (5/7/2010)

---

I'm STILL...

Yes, you may, but they are not historical.

A procedure with 3 statements will have 3...