# Please stop using this UPSERT anti-pattern - SQLPerformance.com

<https://sqlperformance.com/2020/09/locking/upsert-anti-pattern>

- Host: [sqlperformance.com](https://links.thingelstad.xyz/hosts/sqlperformance.com/)
- Saved: September 7, 2020 (2020-09-07T14:15:25Z)
- Record: https://links.thingelstad.xyz/links/af3a6f36a13b/
- JSON: https://links.thingelstad.xyz/links/af3a6f36a13b.json

## What Jamie wrote

I have seen the pain and suffering caused by this anti-pattern. Good to heed the advice here.

## Facts

- Kind: [Page](https://links.thingelstad.xyz/kinds/page/)

## Appears in

- [WT156: Weekly Thing #156 / Identity, AI, Peloton, UPSERT](https://weekly.thingelstad.com/archive/156/), Recommended Links

## Saved the same week

- [Minnesota nonprofits plead for more help as hunger crisis surges - StarTribune.com](https://links.thingelstad.xyz/links/67d0e2f3ee4f/) (startribune.com, September 7, 2020)
- [U.S. court: Mass surveillance program exposed by Snowden was illegal - Reuters](https://links.thingelstad.xyz/links/ad99b0983fb1/) (reuters.com, September 7, 2020)
- [Big-Ass-Data-Broker-Opt-Out-List](https://links.thingelstad.xyz/links/0f5882ea9645/) (github.com, September 7, 2020)
- [Implementing Shape Up](https://links.thingelstad.xyz/links/2c7734f94827/) (ncphi.dev, September 7, 2020)
- [Meet The New Peloton Bike+ And The New Peloton Tread | The Output](https://links.thingelstad.xyz/links/c9497f49c558/) (blog.onepeloton.com, September 8, 2020)

## Elsewhere

- Wayback Machine: https://web.archive.org/web/*/https://sqlperformance.com/2020/09/locking/upsert-anti-pattern