SQL Server - Other Stuff - Feb (A)

There are different ways to find disk latency issues.

- Performance Monitor (Perfmon)

- Virtual File Stats

- OS Wait Types

Disk  I/O from Perfmon

SQL Server - Table Partitioning

https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16

SQL Server - Inner, Cross Join and Merge Join

The cross join is introduced to display the combination/relation for each record from table with all records from other table.

The example of ‘cross join’ is here below.

select * from dbo.HOSP_Patient_Registration_Table CROSS JOIN HOSP_Facility where Is_Active=1

Additionally,

WITH common_table_expression (Transact-SQL)

https://learn.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16

FOR Clause (Transact-SQL)

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

Install SQL Server documentation to view offline in SSMS

https://learn.microsoft.com/en-us/sql/sql-server/sql-server-offline-documentation?view=sql-server-ver16

FROM clause plus JOIN, APPLY, PIVOT (Transact-SQL)

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

Best Regards

Amit Vaid