 |
Post AvYoNc1OhQtQAUacj2 by [email protected] |
 |
More posts by [email protected] |
|
Post #AvWSu7vp0WpD5vA2VM by [email protected] |
|
0 likes, 1 repeats |
|
|
|
Worst SQL sins you've ever seen, go!I'll start.db had six tables, most … |
|
|
|
Post #AvWSu83cXX3zU6oGf2 by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@nuintari some of the worst SQL sins I have seen come from PowerBI...SELECT a,b… |
|
|
|
Post #AvWSu8Tqy02ynT5DY8 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
I have another one.While working for an MSP a few years back, I was given the t… |
|
|
|
Post #AvWYMwjQE9tkWjvGBE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@fbarton I'm pretty convinced sub-selects have no place in production code. |
|
|
|
Post #AvWYMwq9p7Hmrd4dg8 by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@nuintari I won't say "Never"... but yeah... create a view |
|
|
|
Post #AvYTsi0CPojKem13EO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I hear the right way to handle cases like this is to just add half a … |
|
|
|
Post #AvYTsi6w0m7MzfAQjI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@apzpins I mean, the gorram thing had 48 cores and 768 MB ram, but the SAP app … |
|
|
|
Post #AvYTsiDJd3DpJS9Wfw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I'm not a DBA, but I've had to look after some and every time… |
|
|
|
Post #AvYTsiIzHxl7b2o3W4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@apzpins SAP consultants are a special breed of incompetent. They think that be… |
|
|
|
Post #AvYTu8x5ha7sWuFKF6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I have a 470 line long sql query that generates xml files direct out … |
|
|
|
Post #AvYTvm1VvAfzzs5meu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Not that horrific, but worth scratching one's eyes out for, was w… |
|
|
|
Post #AvYTwbgNqyfiDObdwW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari If you ever want to be horrified, check out how Magento constructs SE… |
|
|
|
Post #AvYTywEkP7ioXfn7Uu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@pertho What is Magneto? |
|
|
|
Post #AvYTzTInT5ZL5mwJtI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I worked at a company that had it's database on MySQL 5.5 and it … |
|
|
|
Post #AvYTzTOp6gODOTl8Hg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@pertho I love looking at databases and saying, "This person never took CS… |
|
|
|
Post #AvYU1XDZsdRvofTxWi by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Horribly written, unscalable e-commerce framework written in PHP. I b… |
|
|
|
Post #AvYU3kRTgSyHPS2UiG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@gmc |
|
|
|
Post #AvYU48VCEICq1vxnqC by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@sotolf Yeah, that is probably not the most efficient thing ever.But at least i… |
|
|
|
Post #AvYU48bZqZJILiwtmq by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Yeah true enough ;) This just gets executed a couple of times a week,… |
|
|
|
Post #AvYU48hFVTqadJbQcy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@sotolf 30 seconds twice a week is probably what i call, "good enough effi… |
|
|
|
Post #AvYU48nH94fSw0QF1M by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari yeah, exactly that is why it's been just left running, there are … |
|
|
|
Post #AvYU48swnzClDb4lrU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@sotolf This sounds like the ADB stuff my boss at $weDropPackets relied on for … |
|
|
|
Post #AvYU48ycStk3VBjIhc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Oof, yeah, subselects can get really ugly really fast. |
|
|
|
Post #AvYU72bScOAabUHLay by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I once had a client who was experiencing problems with very long runn… |
|
|
|
Post #AvYU7ahJr73gLVHVRo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@duncan_bayne Transactions, like all tools, can be used correctly, or not. |
|
|
|
Post #AvYU8lWB6yWQC5d8iW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] Idk if those count as necessarily SQL sins, but I c… |
|
|
|
Post #AvYUBfOGLn8w3fJMMy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@ij Sounds pretty sinful to me. |
|
|
|
Post #AvYUBfUdy4FONSISJc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] sinful definitely, I just meant it wasn't direc… |
|
|
|
Post #AvYUBfZxeIV6dwmhbU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@ij Yin/Yang, Potayto/Potahto. |
|
|
|
Post #AvYUBffdJD2OvXRERc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] fair |
|
|
|
Post #AvYUH3gZRsFErARhHE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I once glanced inside the DB of a custom application in use at a clie… |
|
|
|
Post #AvYUJRZxaItbXWUVWK by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@root Bad design and shady tracking? A two-fer! |
|
|
|
Post #AvYUN5yDroaZgDa4iO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Working a few years in the optimization team of a hyper scaler I'… |
|
|
|
Post #AvYUNtsGKFWwSDB1Mm by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Yup! This was ... not |
|
|
|
Post #AvYURWtRi5AUL2Sdwu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Yeah, but that one isn't too bad, the way data gets imported is w… |
|
|
|
Post #AvYUUDERGcawEDYkiW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari i once encountered a doubly linked list, need i say any more? |
|
|
|
Post #AvYoIRitYrxEmRTKSW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari the worst I can think of was the db for a POS + ERP system. One of th… |
|
|
|
Post #AvYoIRpHB93h6ESQPA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@mdione Ohhhh, now that is special. I mean it's a way to do it. Queries pro… |
|
|
|
Post #AvYoNbnDY9YBSVxIci by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari @pertho wow! there’s a name i haven’t heard in ages. |
|
|
|
Post #AvYoNbv159mxqhbWmO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dr_a @pertho You also a Falcon?Sadly, I do believe Dr Tilson is deceased.I las… |
|
|
|
Post #AvYoNc1OhQtQAUacj2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari @pertho It looks like Ron Conway is the only faculty member left from… |
|
|
|
Post #AvYoNc74MLQiS5F9ZA by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dr_a @pertho Same, only name/face I recognize was Bones, I was late 90s to 200… |
|
|
|
Post #AvYoNcDnxIokmyOX44 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari @pertho my partner and i used to run into Dr. Barnes from time to tim… |
|
|
|
Post #AvYoNcJpatdd5fDLSS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dr_a @pertho You still in the area? I live in Perrysburg Township. |
|
|
|
Post #AvYoNclTw5kwTQ9QYa by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dr_a @pertho Fun fact, when alpha, sigma, and delta got retired, alpha fell of… |
|
|
|
Post #AvYoiwmwgSR6en0GNU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari @dr_a Don't see any mention of him on BGSU's site. What was h… |
|
|
|
Post #AvYok7Q6doXfv5sYPg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari Gladly and with dread, I've not yet been exposed to much database… |
|
|
|
Post #AvYok8WWXRGnLHtC3U by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari (Table inheritance, a sin in itself?) |
|
|
|
Post #AvYonhh8EI4NIBYHlw by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I don't know, really. (un)Luckily we run out of funds and the pro… |
|
|
|
Post #AvYonhn9rstFasN6AK by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@mdione honestly, databases other than SQL or even relational exist, I should j… |
|
|
|
Post #AvYot6hkfccIJ7Q0kS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@pertho @dr_a I can't remember, but he is most certainly long since retired… |
|
|
|
Post #AvYotPKLQsBO41c5Oy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari @pertho nope, headed to the PNW years ago. |
|
|
|
Post #AvYp6BXW0PJJ4Drmt6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@silverwizard Yeah, better disks, add some SSD (at the time that was the fastes… |
|
|
|
Post #AvZAxWI3gRhDoFuTiq by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari A database where "It's too hard to add new columns" so … |
|
|
|
Post #AvZAxWO5K2W66wjI7E by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@phs Oh lord, I cry whenever I see key values stuffed into RDBMS varchar fields… |
|
|
|
Post #AvZAxWUSwJcYQjiO3s by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@nuintari I forgot the part where indexes are created on values *inside the JSO… |
