Friday, April 21, 2023

MS-SQL Server - Jor Jemry & Joins

Jor Jemry & Joins


Again Jor Jemry is nothing but Job Step Retry & Intervals which is another Jem achievement by Microsoft.


This allows us to automate the frequent retries when environment accept that there may be some conflict/issue occurs during original job scheduled time.


Additionally,


Major Joins,

- Inner join
- Left outer join
- Right outer join

https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16

Rich Text to SQL Server Database

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/88a5b103-6764-4ea4-b3eb-c41e0656c81c/saving-richtextbox-formatted-text-to-a-sql-server-2014-database?forum=vbgeneral


DataTypes

- Numeric

- Spatial Geography


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


Best Regards



T. Amit Vaid S.

No comments: