MS-SQL Server - Make DB Read Only

Make DB Read Only..

There are some environments where we may have to change our database to Read Only.

https://learn.microsoft.com/en-us/answers/questions/63706/access-to-read-only-database-to-a-non-sa-user

Additionally,

Deadlock Chain

https://learn.microsoft.com/en-us/sql/relational-databases/event-classes/lock-deadlock-chain-event-class?view=sql-server-ver16

How to calculate age from date of birth

https://learn.microsoft.com/en-us/answers/questions/481579/how-to-calculate-age-from-date-of-birth

Add Signature

https://learn.microsoft.com/en-us/sql/t-sql/statements/add-signature-transact-sql?view=sql-server-ver16

Deep Analysis of below Waittype
CXPACKET
HADR_TDS_LISTENER_SYNC_PROCESSING

FT_RESTART_CRAWL

Days between two dates

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

CTE & Join

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

Best Regards

T. Amit Vaid S.