Don't use DISTINCT as a "join-fixer" - Simple Talk
10/22/2023 - 🖒 22
Published by Pinboard (popular bookmarks)
view data
{
"fingerprint": "db61696e",
"id": "uW6OVyMOU/Wf09ueJdtxBuVG3zPAAxiGRBuAOlsem8k=_18b5638d1c5:616229:1883a5ef",
"language": "en",
"keywords": [
"s"
],
"originId": "https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/dont-use-distinct-as-a-join-fixer/",
"origin": {
"streamId": "feed/http://feeds.pinboard.in/rss/popular/",
"title": "Pinboard (popular bookmarks)",
"htmlUrl": "https://pinboard.in/popular/"
},
"title": "Don't use DISTINCT as a "join-fixer" - Simple Talk",
"content": {
"content": "Comments",
"direction": "ltr",
"unsanitized": "<html><head></head><body>Comments</body></html>"
},
"author": "igorette",
"crawled": 1697958646213,
"published": 1697953621000,
"alternate": [
{
"href": "https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/dont-use-distinct-as-a-join-fixer/",
"type": "text/html"
}
],
"visual": {
"processor": "feedly-nikon-v3.1",
"contentType": "image/png",
"url": "https://www.red-gate.com/simple-talk/wp-content/uploads/2023/09/joinfix-p1.png",
"width": 2498,
"height": 686
},
"canonicalUrl": "https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/dont-use-distinct-as-a-join-fixer/",
"unread": false,
"readTime": 90708,
"categories": [
{
"id": "user/447f76f6-44df-414e-a9af-794a73847bdb/category/global.must",
"label": "Must Read"
},
{
"id": "user/447f76f6-44df-414e-a9af-794a73847bdb/category/News",
"label": "News"
}
],
"tags": [
{
"id": "user/447f76f6-44df-414e-a9af-794a73847bdb/tag/global.read",
"label": ""
},
{
"id": "user/447f76f6-44df-414e-a9af-794a73847bdb/tag/Dev",
"label": "Dev"
}
],
"actionTimestamp": 1698437235215,
"engagement": 22
}