I got some quality SQL Server/database work done with one of the dev team members this week.
It started out with a request to delete duplicate data from a table. After deleting the dupes, we analyzed the table and identified a natural key and added a composite unique index--no more duplicate data going forward.
1/X
#SQLServer
#RDBMS
#Development
Dave Mason
npub1tp…ppq9v
2024-10-25 13:49:05 UTC
Author Public Key
npub1tpwj0yfuykzlugwq38z23sun0dddjutzg5guxawvzd872y3kv9tqkppq9vSeen on
wss://relay.momostr.pinkPublished at
2024-10-25 13:49:05 UTCEvent JSON
{
"id": "a64de1380b21c82eae4da2801454714dc34fc99667997d7bfd105a7d24043d1d",
"pubkey": "585d27913c2585fe21c089c4a8c3937b5ad971624511c375cc134fe512366156",
"created_at": 1729864145,
"kind": 1,
"tags": [
[
"t",
"development"
],
[
"proxy",
"https://mastodon.social/@DaveMasonDotMe/113368376647707276",
"web"
],
[
"t",
"rdbms"
],
[
"t",
"sqlserver"
],
[
"proxy",
"https://mastodon.social/users/DaveMasonDotMe/statuses/113368376647707276",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.social/users/DaveMasonDotMe/statuses/113368376647707276",
"pink.momostr"
],
[
"-"
]
],
"content": "I got some quality SQL Server/database work done with one of the dev team members this week.\n\nIt started out with a request to delete duplicate data from a table. After deleting the dupes, we analyzed the table and identified a natural key and added a composite unique index--no more duplicate data going forward.\n\n1/X\n\n#SQLServer\n#RDBMS\n#Development",
"sig": "202039ca8fbf593024610e20a51e21766f3fc9237968bc57281f1712be9233ea79784426b9deedc98b45ad6c63e621e3c9b871972c47eb3568e9ef1d86d18f9a"
}