Hai All
1. Previously the Max Degree of parallelism was set to 4 and when i set it to 0 my Whole database was DeadLocked.Please let me know wat will be the issue and how to solve this.I used SP_CONFIGURE for changing the Max Degree of parallelism.
2. I have created new indexes on a tables is that necessarry to create statistics manually or else SQL Server will take care of it. If not,How to Update the statistics for a particular table.
Thanks in Advance
Regards
Senthil
1. Previously the Max Degree of parallelism was set to 4 and when i set it to 0 my Whole database was DeadLocked.Please let me know wat will be the issue and how to solve this.I used SP_CONFIGURE for changing the Max Degree of parallelism.
2. I have created new indexes on a tables is that necessarry to create statistics manually or else SQL Server will take care of it. If not,How to Update the statistics for a particular table.
Thanks in Advance
Regards
Senthil