sp_replrestart command worked for me .  No Parameters required , you can simply run this command on the DB where you have this issue. Note that all the publications on...

you can use sp_who2 to see all processes and check which SPID is actaully causing blocking and kill that... To automate that you can write take the results of Sp_who2...

You can use Windows Scheduler to schdule your SSIS package execution.

Another tool which can call SSIS package is Control-M .

I had used Windows scheduler as well as COntrol-M...

Fair point Jeff. There shouldn't be really any doubt that if we replicate tables locally and use local tables in our join then performance will be definitely be better than...

Try the below query , even if you skip one parameter it simply uses that columnName during comparison

alter procedure spGetDetails

(

@AccountID nvarchar(10)= null ,

@Name nvarchar(20) = null

)

as

begin

select * from...

Hi Anand, Good to know that the query helped you. Indexes are categorized only in 2 categories Clustered and non-clustered Index. However, when you create an INDEX and you mention...

There are scripts to fetch the scripts for an index but its a big code , not a MS provided procedure/function like sp_helptext... you can refer one in below link......

Check the below code, ISNULL function should help to resolve this. Adding Recompile will take care of changing the query plan in case the variable is NULL and you end...

Your query is spending maximum time in Sorting the data. I checked your view and I see it uses "TOP 100 PERCENT " ... If you are getting 100 Percent...

Can you try below steps

1. Ensure that the 3 variables are declared as below

DECLARE @SQL1 Varchar(4000)

DECLARE @SQL2 Varchar(4000)

...

I guess you need to refer DEPTCode without prefixing it with P. as Deptcode is not present in the stage_chris21.PSDET table. Try the below code and see if it...

Good point .. this is another difference between procedure and a function

When you create a function ,SQL server will allow you to call a procedure from the Function.

However when...