MS-SQL Server - Rank, Joins, Features, Versions, Job Schedule Query & 'WHERE' (A Questionnaire)

Rank, Joins, Features, Versions, Job Schedule Query & 'WHERE' (A Questionnaire)

Rank
https://learn.microsoft.com/en-us/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16

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

Features
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16

& Versions
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates

Job Schedule Query https://learn.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver16

Business Analytics from SSAS
https://learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions

Security Update for version: 10.50.6785.2

https://support.microsoft.com/en-gb/topic/kb5021112-description-of-the-security-update-for-sql-server-2008-r2-sp3-gdr-february-14-2023-844419ed-d837-467f-97e8-eed2e281c40c

Deep Audit on
- Security & Permission
- Password Reset
- Configuration

Imp. Waittype
PREEMPTIVE_CLOSEBACKUPVDIDEVICE
IMPPROV_IOWAIT
AUDIT_ON_DEMAND_TARGET_LOCK
FFT_NSO_FCB_PARENT
BROKER_CONNECTION_RECEIVE_TASK
CLRHOST_STATE_ACCESS
EXECUTION_PIPE_EVENT_INTERNAL

ASYNC_NETWORK_IO

QUERY_OPTIMIZER_PRINT_MUTEX

5 Wheres
- Where can we find CPU Usage?
- Where can we find job History?
- Where temp tables are created?
- Where we should keep backup logs?
- Where we can change the setting for auto stats?

Imp. Error Msg. 2536

Any query will be considered.

T. Amit Vaid S.