Viewing 15 posts - 27,481 through 27,495 (of 49,552 total)
pwalter83 (3/9/2011)
GilaMonster (3/9/2011)
Could you post table definitions, sample data and expected result please?
Now this is really frustrating. Without even reading the question, you have replied in a template answer. This...
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
March 9, 2011 at 7:06 am
Depends on what you want the delete trigger to do. Your description earlier wasn't very clear. Same kind of pattern should be applicable.
One thing that the trigger doesn't take into...
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
March 9, 2011 at 6:49 am
GSquared (3/9/2011)
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
March 9, 2011 at 6:46 am
Kit G (3/9/2011)
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
March 9, 2011 at 6:29 am
Ivan Mohapatra (3/9/2011)
sir it is a trace where i can'nt find the query which is been run and from which machine-pc.
Sorry, I don't understand what you're asking.
If you want something...
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
March 9, 2011 at 6:00 am
Here's a modification of your trigger that will work with multiple rows inserted. I think it's correct, haven't tested.
ALTER TRIGGER [dbo].[articlecount]
ON [dbo].[orderitem]
AFTER INSERT
AS...
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
March 9, 2011 at 5:56 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1075440-1633-1.aspx
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
March 9, 2011 at 5:46 am
Could you post table definitions, sample data and expected result please?
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
March 9, 2011 at 5:45 am
Post the current code that you have for the delete trigger please.
p.s. your insert trigger does not work for multiple rows inserted
DECLARE @ArticleNR AS NVARCHAR(20),
...
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
March 9, 2011 at 4:12 am
Log shipping between versions does work, but bear in mind if the prod server ever fails and you have to use the DR box, you'll never be able to go...
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
March 9, 2011 at 2:33 am
Backups in SQL are online and don't stop apps from connecting or querying.
Stack dumps are problems. Check that you're on the latest patch (SP4), if you are then contact CSS...
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
March 9, 2011 at 2:31 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1075325-1550-1.aspx
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
March 9, 2011 at 1:15 am
Please don't post in all caps. It's like shouting at us.
To trace queries executed you need SQL profiler or a Server-side trace. See http://www.sqlservercentral.com/stairway/72363/
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
March 9, 2011 at 1:14 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1075325-1550-1.aspx
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
March 9, 2011 at 1:11 am
Rajat Jaiswal-337252 (3/8/2011)
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
March 9, 2011 at 1:07 am
Viewing 15 posts - 27,481 through 27,495 (of 49,552 total)