MS-SQL Server - Topics for Today

Topics

Tutorial Sample Database

https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16

- Keys & Constraints

- Schedules Job Analysis

- Log Backup & LogShrink

- Numeric & other Datatypes

Additionally,

SQL Server has four types of physical join operations to carry out the logical join operations:

Nested Loops joins

Merge joins

Hash joins

(starting with SQL Server 2017 (14.x)) Adaptive joins

Disk Latency & Troubleshoot slow SQL Server performance

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-sql-io-performance

Best Regards

T. Amit Vaid S.