Monday, June 5, 2023

MS-SQL Server - Ultimate Pivot, TRY Catch EH & Round

Ultimate Pivot, TRY Catch EH & Round


Ultimate Pivot.

https://amit-sqldbasupport.blogspot.com/2022/11/sql-server-ultimate-pivot-script.html?m=1


Begin Try

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver16


Round Function

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


Checkpoint

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


Imp. Waittype

CHECKPOINT_QUEUE

AUDIT_ON_DEMAND_TARGET_LOCK

HADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LIST


Internal Use only

SCAN_CHAR_HASH_ARRAY_INITIALIZATION

AUDIT_ON_DEMAND_TARGET_LOCK

FABRIC_REPLICA_PUBLISHER_EVENT_PUBLISH

SQLTRACE_INCREMENTAL_FLUSH_SLEEP


Databases Errors




Any query will be considered.



T. Amit Vaid S.

No comments: