MS-SQL Server - Duplicate, NC Index & A Quality of Joins

Duplicate, NC Index & A Quality of Joins

Duplicate Rows
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/development/remove-duplicate-rows-sql-server-tab

NC Index
https://learn.microsoft.com/en-us/sql/relational-databases/indexes/create-nonclustered-indexes?view=sql-server-ver16

Joins
https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16

Additionally,

DBCC Error Msg 8970
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3984d173-f349-407f-b708-c3baa006e5d6/dbcc-error-in-full-text-internal-table?forum=sqldatabaseengine

Common Errors

System Databases

https://learn.microsoft.com/en-us/sql/relational-databases/databases/system-databases?view=sql-server-ver16

Configure the max degree of parallelism (server configuration option)

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver16

Imp. Errors

Specially 688 which occurs during online rebuild index.

Any query will be considered.

T. Amit Vaid S.