Wednesday, March 29, 2023

MS-SQL Server - Thank God I am Busy!

Thank God I am Busy!


Datatype Hierarchy and Datatype of Bigint


https://learn.microsoft.com/en-us/sql/t-sql/data-types/hierarchyid-data-type-method-reference?view=sql-server-ver16


Data Type


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


Key Joins, Inner Join, Outer Join and Cross Join, Begin Tran, Commit Tran


Network Attached Storage


https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/support-network-database-files


GHEAR


- Global Variable

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

- History Cleanup

- Error Log Auto Cycle

- Allow Remote Connection



KANEA

Keys and Constraints

Normalisation

Event Log

Auto Identity



GRA-Hat

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-faq


Raiserror

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


Keys and Indexes


https://learn.microsoft.com/en-us/answers/questions/745795/indexes-and-keys


Best Regards


T. Amit Vaid S.

No comments: