thank you!

sorry here it is

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED VS WITH(NOLOCK)

hi, i have noticed that my trigger has been causing a lot of exclusive locks

here is my code

ALTER TRIGGER [dbo].[tr_updDistName] ON [dbo].[tblDistributors]

AFTER INSERT

AS

BEGIN

set nocount on;

UPDATE...

Thank you, i will follow your advice and leave the trigger using the inner joins, its working great. I solved my other problem of the rowcounts with the set...

thanks! this is what i did and it seems to be working perfectly (still testing)

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[tr_updDistName] ON [dbo].[tblDistributors]

AFTER INSERT

AS

DECLARE @DistID_FK int,@DistID_FK int,

@DateInserted datetime

Select @DistID_FK...

thank you for your replies, here is the code for my trigger:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[tr_updDistName] ON [dbo].[tblDistributors]

AFTER INSERT

AS

DECLARE @DistID_FK int,@CodeID_FK int,

@DateInserted datetime

Select @DistID_FK = (Select...

thank you, i am adding around 150k rows into the temp table, so is it safe to say that it is better to do the insert first like in the...

another two questions if you don' t mind, is it neccesary to do this before creating the clustered index for the temp table?

IF EXISTS (SELECT name FROM sysindexes WHERE...

thank you, can you please tell me why would this way be faster?

thank you guys, my bad, i had an extra criteria in my query. :blush:

THANK YOU!

thank you, so its not really needed to do an update statistics after these stored procedures parameter sniffing issues has been fixed? would it make any difference? i don't have...

hi just a quick question, i was able to identify some stored procedures with parameter sniffing and was able to fix them. After updating this stored procedures, should i...

thank you 🙂

hi but we are talking about many stored procedures, how would i know the ones that have the have the parameter sniffing problem? do i have to check each one?...