Thanks for clarification and sharing the best practice link , about Max DOP set to 1 , I didn't mention this value at all for any one , the only...

Hello Michael

Quick questions. Have you ever partitioned a table? If so, can you provide some actual facts as to what the performance gains you realized?

Yes , I did this...

Hello Srinivas ,

Try using Powershell with Windows scheduler task .

https://technet.microsoft.com/en-us/library/ee176942.aspx

Regards,

Abdullah. Zarour

Just to share with you my way to troubleshooting such issues :

1. try to get workload files from production .

2. Run DTA (Database Tuning Advisor ) .

which will give you...

Hello SSC-Enthusiastic ,

You might try the following point :

1. Create a table partition.

2. Configure the SQL Server Instance Option ( Optimize for Ad hoc workloads).

3. Check Max Degree...

Hello This is a sample empty code body for your reference :

CREATE TRIGGER DeleteMedicalGroup ON dbo.MedicalGroup

INSTEAD OF DELETE

AS

BEGIN

ROLLBACK;

END;