Viewing 15 posts - 33,001 through 33,015 (of 49,552 total)
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.
May 9, 2010 at 12:51 pm
Robert Frasca (5/7/2010)
May 7, 2010 at 2:45 pm
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?
May 7, 2010 at 2:28 pm
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...
May 7, 2010 at 2:22 pm
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....
May 7, 2010 at 1:43 pm
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,...
May 7, 2010 at 1:37 pm
CirquedeSQLeil (5/7/2010)
Gail, now that you are more active in the forums again, does this mean that you are done with school for a bit?
No. Thesis is due end of the...
May 7, 2010 at 11:57 am
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.
May 7, 2010 at 10:54 am
CirquedeSQLeil (5/7/2010)
I can see the attitude but I gave up on finding the history and references to his Phd.
It's well over a year ago, possibly longer. In summary...
He...
May 7, 2010 at 10:52 am
Lynn Pettis (5/7/2010)
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
I'm STILL...
May 7, 2010 at 10:47 am
CirquedeSQLeil (5/7/2010)
There are cumulative results, but one may also see numerous entries in that view.
Yes, you may, but they are not historical.
A procedure with 3 statements will have 3...
May 7, 2010 at 10:44 am
Viewing 15 posts - 33,001 through 33,015 (of 49,552 total)