Indexing https://www.webfaq.cz/clanek/MSSQL-UPSERT-INSERT-INTO-ON-DUPLICATE-KEY-UPDATE