MS-SQL Server - Alter Index {MaxDOP}

Alter Index {MaxDOP}

https://learn.microsoft.com/en-us/sql/relational-databases/indexes/configure-parallel-index-operations?view=sql-server-ver16

Merge

https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16

Candidate Key Profile Request Option

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/candidate-key-profile-request-options-data-profiling-task?view=sql-server-ver16

Use of CROSS & OUTER

https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16

Job History

https://learn.microsoft.com/en-us/sql/ssms/agent/view-the-job-history?view=sql-server-ver16

All Mandatory Performance Counters

- Buffer Cache Hit Ratio

- Page Life Expectancy

- High CPU

- Total n Target Memory

- Disk Read Writes

Best Regards

T. Amit Vaid S.