Thanks Gail.

I will doing following steps:

1) I will be creating one or two new filegroup as we have only one PRIMARY FILE GROUP

2) I will create the partition function for...

Thanks Gail.

Is it Ican add the partition into exisisting table or i need to create new table and then copy it??

Gail,

you right and i am agreed with you as we are planningto switch the query to access the specific partition and same thing for Delete.

I will create Partition function, scheme and add the partition but i need to know that i can create partition into exisisting table or i have to create new table,...

Thanks.

We need to improve the performance. We have few slower queries whcih we also tried to improve with indexes and we have everyday lots of blocking due to insert/update.

We also...

Sure, We don't have any choice right now so i will run first stored proc and then i will try to run and compare the performance with your CTE.

I am...

Thanks Sean, appreciate your help!

So my procedure modification as you have suggested is fine, right?

I will implement this one first and then i will try to implement CTE sql.

any other solution?

CREATE PROCEDURE [dbo].[Purge_DupsRecords]

(@NumberOfRows int=20000)

AS

BEGIN...

You are right, Design is major issue and i don't know what's the plan here but i can definayely suggest them.

Due to avoid locking, they have implemented looping and going...

I do completely agree with you but i have just started and suggested to create DEV but company is small and i don't when they will do?

My procedure modification is...

Thanks Sean once again for your resposnse.

I need for 45 minutes check but i can also set up as 30 minutes.

I was trying to implement in one shot like you...

Thanks Sean.

If you don't mind could you please look at my code and correct me if i have mistaken as i am not as i am not programmer.

appreciate your help...

Thanks.

We don't need to stop at certain time clock, we need to quit the job (stored procedure) in it's running more than 45 minutes as currently it's runnning from 20...

Thanks Jeff, This is a very nice tip, i will make sure it.

Thank you so much for all great efforts to help!

Thanks.

I have created Linked Server and use the script Insert INTO...Select * from ... Where...

Thanks so much!