|
Microsoft SQL Server is the best, thread loving over.
|
# ¿ May 12, 2016 20:30 |
|
|
# ¿ Apr 29, 2024 07:52 |
|
Ok I'll allow a limited number of alternative SQL databases. Go
|
# ¿ May 12, 2016 20:37 |
|
lmfao
|
# ¿ May 12, 2016 20:38 |
|
first post to refute the ultimate truth of my post, and you bring up loving postgres
|
# ¿ May 12, 2016 20:39 |
|
SQL server has had absolutely no parallel since 2012. Maybe oracle but that poo poo is loving expensive for what you get.
|
# ¿ May 12, 2016 20:41 |
|
microsoft are even putting it on linux now so really there is no excuse to not use it if you're actually serious about your databases
|
# ¿ May 12, 2016 20:44 |
|
Captain Foo posted:im enjoying* the op taking the anti-shaggar gimmick in one thread and the shaggar gimmick in another this has nothing to do with gimmicks. to tell you the truth i really don't like windows poo poo but i have to hand it to microsoft, SQL Server is ridiculously versatile.
|
# ¿ May 12, 2016 21:07 |
|
yard salad posted:my company uses oracle. that's not the funny part. the funny part is that we promoted half the DBAs to management and fired almost all the rest, so if we want a table change it's a 2+ month wait. DBAs dont actually design the table changes, they just make sure the table and column names fit with the company policy and press the "Approve" button. upper management is helpless to fix the situation
|
# ¿ May 12, 2016 21:17 |
|
Captain Foo posted:you're out of your depth. sounds like you have something interesting to say about this database technology. let's hear it then
|
# ¿ May 12, 2016 21:21 |
|
my stepdads beer posted:hope you've intenalised the 1000 weird mysql edge cases Although you could probably make a list this large on the MSSQL MERGE syntax alone
|
# ¿ May 12, 2016 23:30 |
|
YeOldeButchere posted:mysql has a query optimizer? the best thing about mysql is the stored procedures don't have their query plans cached server side. they are generated every single time a connection is opened.
|
# ¿ May 12, 2016 23:31 |
|
At least mysql has on the wire compression going for it. It's a real shame nothing like that is supported by SQL server.
|
# ¿ May 13, 2016 00:46 |
|
Yes?
|
# ¿ May 13, 2016 01:12 |
|
tef posted:isn't that about the same time it got row numbering, or was that 2008 2012 was the first version that came with alwayson availability groups, which are super great
|
# ¿ May 13, 2016 01:33 |
|
Share Bear posted:im curious how mysql got more adoption than postgres, or seems to have been more widely adopted in the 00s yes it's because php
|
# ¿ May 13, 2016 17:46 |
|
I'm getting a poor vibe about oracle ITT. I mean I've not actually had to use it personally, and I've heard it has some nice performance features which are unrivaled, but also that it costs an order of magnitude higher than basically everything else. Databases corrupting themselves on a semi regular basis isn't something that sounds all that great to work with, however.
qhat fucked around with this message at 21:10 on May 13, 2016 |
# ¿ May 13, 2016 21:06 |
|
Bloody posted:we use a combination of xlsx, cvs, and mat files stored in SVN lmaao
|
# ¿ May 14, 2016 09:47 |
|
compuserved posted:vertica is p deece for olap yeah it is. it's also got a weird bug where if you're using more than say 2000+ placeholders in a query the driver will suck up many gigs of memory and won't give it back to the OS
|
# ¿ May 16, 2016 10:14 |
|
how do you do foreign keys in excel
|
# ¿ May 17, 2016 00:15 |
|
you know you can just save it all to csv and probably load it into an sqlite db in about 5 seconds right
|
# ¿ May 17, 2016 00:17 |
|
akadajet posted:but there are better dbs out there that don't have limits and run non-poo poo-tier OSes that don't require you to buy expensive licenses for example
|
# ¿ May 17, 2016 14:27 |
|
i mean if you're making some awful hobbyist website then you can easily get away with mysql or even sqlite, or basically loving anything since it doesn't matter but if you care about enterprise features for example not complete dog poo poo replication and failover then you should be seriously considering investing some money into what's going to be one of the most critical technologies in your business and microsoft is putting sql server on linux soon anyway so the windows requirement won't even be a thing eventually
|
# ¿ May 17, 2016 14:37 |
|
ok so he was talking about personal project things anyway but since there's no reason to use mysql in the real world then you're should probably learn how to make dbs the correct way, else you may as well just check plaintext csv files into svn because who cares
|
# ¿ May 17, 2016 14:43 |
|
so it's at least equally as useful as mysql nice
|
# ¿ May 17, 2016 14:45 |
|
one thing that annoys me about sql server is SSMS 2014 is horse poo poo and doesn't save connection parameters in the dialog box so the program disconnects from the DB every 5 minutes and you have to type out the loving connection string again. SSMS 2016 fixed that though so once again SQL server is the best
|
# ¿ May 17, 2016 14:51 |
|
Shaggar posted:doesn't do that on my pc. we use multisubnetfailover and idk if you use that but apparently it's a known problem, since without that option half of the connection attempts will just fail. they should just do the logical thing and have that setting as a checkbox somewhere like in visual studio, but they don't so idk. at least the connection parameters are actually saved between connection attempts now.
|
# ¿ May 17, 2016 14:57 |
|
why can you not trust the tool that has been provided by the exact same company that creates the database apart from the fact that that company happens to be oracle
|
# ¿ May 17, 2016 17:17 |
|
It's cool how you can make a boatload of money while knowing next to nothing about your primary trade
|
# ¿ May 17, 2016 19:51 |
|
Shaggar posted:we have a consultant with us right now whos contracted for 6 months cause hes actually really goddamned good. first consultant I've ever met who knew what he was doing. this is how i imagined it should be, you pay more money and you get someone who can do the job right now. evidently not though.
|
# ¿ May 17, 2016 20:40 |
|
zen death robot posted:The Bible didn't tell them it was OK to set the systems max shared memory size to be absolute maximum a 64 bit OS would ever allow and go hog wild with SGA sizes and then bitch to me that the storage speeds are loving trash because they're swapping the loving DB cache out to disk constantly like a bunch of loving idiots/ Lol
|
# ¿ May 18, 2016 00:36 |
|
zen death robot posted:I mentioned they could just allow orcale to automatically handle the memory management and they argued with me that there's a "bug" that wouldn't allow them to use more memory than existed on the system. Lmao
|
# ¿ May 18, 2016 00:38 |
|
Idk is Oracle one of those DB that expects you to start loving around with resource and memory management? I know some of our systems guys do that for Vertica but still end up blocking users out of the clusters when some team runs a huge data load.
|
# ¿ May 18, 2016 00:43 |
|
sql server can do that also
|
# ¿ May 18, 2016 17:53 |
|
"Why Do Computers Stop and What Can Be Done About It?" Lol
|
# ¿ May 18, 2016 19:16 |
|
i've only ever implemented a non-trivial mysql production database once and that was and will be the last time
|
# ¿ May 19, 2016 17:55 |
|
it's un loving believable the amount of hoops you have to jump through to get that DB to work well enough to be considered production ready. but hey i guess if you hate stored procedures and replication because you see those features as just unnecessary and for spergs only, then go loving nuts
|
# ¿ May 19, 2016 17:58 |
|
Tiny Bug Child posted:you can do both of those things w MySQL and it's not hard i already said you can do them but the way they are implemented in mysql is near totally worthless for production systems
|
# ¿ May 21, 2016 12:52 |
|
MALE SHOEGAZE posted:why is that? just wondering because we have a thing in maria db and it sucks rear end and we want to go to post gres but we wont be able to get `platinum support` from our massive ops team so we're sorta stuck with mysql unless we want to support the db ourselves (we do not) easily the most glaring and severe problem with mysql replication is it's all done in a single thread on the replicas. basically when changes happen on the master they get written to what's called a binary log, and when a slave connects to the master two threads are set up, one that streams the log constantly from the master and the other which executes replication events contained within the log. the thread which executes the replication events from the log is what i mean by single threaded being a limitation. i suppose it's not a huge deal if your use case is fairly small with a low amount of writes and mostly reads, but if you have fucktons of writes coming in then it's a real possibility that your replication will not be able to keep up. ratio doesn't even really matter with large enough DBs, eventually writes are going to scale up. we used to use mysql at our company back in the earlier days and the way we got around it was building an application layer toolkit which literally replicates write queries out to two identical db hosts lol. yeah it's ugly, especially when one of the boxes goes out of service for whatever reason, but still more scalable than dogshit mysql replication. now we use SQL server mostly though and it's great. also wrt stored procedures, when most people think of server side stored procedures, they think about the performance benefits of having the query plans generated and cached server-side waiting and ready for any lucky soul who wants to call it. no not with mysql though, query plans are generated every single time for each new connection, so it's kind of pointless for application that have a high volume of re-connections (like basically any web app that doesn't cache connection objects).
|
# ¿ May 22, 2016 12:50 |
|
Displeased Moo Cow posted:I know how to HTML is that like sql? how about i inner join your face with a table
|
# ¿ May 23, 2016 10:22 |
|
|
# ¿ Apr 29, 2024 07:52 |
|
spankmeister posted:7 pages and nobody posted http://howfuckedismydatabase.com ? lol i read that article about the nuclear material and saw "SQL Server 6.5" and thought god dang that's old as gently caress, but then i realised the article was written 14 years ago
|
# ¿ May 23, 2016 13:53 |