Viewing 6 posts - 1 through 6 (of 6 total)
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...
January 13, 2016 at 10:47 pm
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...
January 13, 2016 at 5:33 pm
Hello Srinivas ,
Try using Powershell with Windows scheduler task .
https://technet.microsoft.com/en-us/library/ee176942.aspx
Regards,
Abdullah. Zarour
January 13, 2016 at 4:56 pm
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...
January 13, 2016 at 4:23 pm
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...
January 13, 2016 at 3:54 pm
Hello This is a sample empty code body for your reference :
CREATE TRIGGER DeleteMedicalGroup ON dbo.MedicalGroup
INSTEAD OF DELETE
AS
BEGIN
ROLLBACK;
END;
January 13, 2016 at 3:38 pm
Viewing 6 posts - 1 through 6 (of 6 total)