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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 9, 2010 at 12:51 pm
MARS? Multiple Active Result Sets.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2010 at 3:02 am
Robert Frasca (5/7/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2010 at 1:37 pm
b.noof (5/5/2010)
but after i migrate from oracle to sqlserver it come a like u see it
i do the migrate with swiss its a soft...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2010 at 1:29 pm
Halcyon (5/7/2010)
let me guess a variable? a table variable?
No. It's a real table. A table variable would be prefixed with an @ sign. This table isn't.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2010 at 1:26 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2010 at 11:57 am
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2010 at 11:04 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 7, 2010 at 10:44 am
Viewing 15 posts - 33,001 through 33,015 (of 49,552 total)