|
Member 4723455 wrote: Why would anyone still use an MS database except for legacy applications?
Because their boss tells them to? It's why I did it, even though I wouldn't use SQL Server for my own projects, a pay check is a good reason IMO.
|
|
|
|
|
Because MS SQL Server is faster and more flexible. It supports more functionality and data types (spatial). It more scalable, so when this little prototype project gets 20 million users next month, it will handle it. I can easily partition SQL Server tables. SQL Server is much more secure, but still open to more protocols and endpoints (Have you seen using SQL Server Data Services to query and update data using https, without having any remote persistant connection to the database? Awesome.) MySQL has no BI or reporting capabilities. SQL Server also has ability to extend procedures and code using a more appropriate language (like .Net) when needed. SQL Server has asynchronous queue handling (Broker Services) for processing less-critical non-transactional updates.
Basically, if ISAM is what you want and all you need, feel free to use the MySQL toy. When you need grownup relational databases, go with SQL Server.
|
|
|
|
|
mharr wrote: Because MS SQL Server is faster and more flexible.
I stopped giving you the benefit of the doubt that you had a clue of what you're talking about right after this line.
mharr wrote: It supports more functionality and data types (spatial).
Yup, we can stop right here folks. Your post is a waste of time, but just for the heck of it...
http://dev.mysql.com/doc/refman/5.0/en/mysql-spatial-datatypes.html[^]
|
|
|
|
|
|
there are other DBs around. Some other solution will also do a fine job.
Greetings from Germany
|
|
|
|
|
Yeah. I object to crumpets not being included in this survey too. They are better than any database. Great with butter.
(KarstenK, the survey was about what versions of SQL Server you use, not what database you use. It is useful to know how rapidly new versions of SQL Server are being adopted. This is a Microsoft site afterall with plenty of SQL Server related advertising.)
p.s. I don't use SQL Server. MySQL here.
p.p.s It seems the survey has changed before I got here. My point still stands though.
|
|
|
|
|
I like to be a little stupid in not playing such "politics", because I hate them.
I dont want to glue to something, if there are better alternatives.
Greetings from Germany
|
|
|
|
|
KarstenK wrote: I dont want to glue to something, if there are better alternatives.
That just makes you wise. So, just be happy you don't belong to the other camp.
|
|
|
|
|
It is a Microsoft SQL Server survey.
|
|
|
|
|
Paul Watson wrote: It is a Microsoft SQL Server survey.
Yeah, I was more so referring to him be able to go against the grain 'round these parts where MS is the way, the truth, and the light, and the only way to get to, um, well, Bill G maybe?
|
|
|
|
|
Paul Watson wrote: KarstenK, the survey was about what versions of SQL Server you use, not what database you use. It is useful to know how rapidly new versions of SQL Server are being adopted. This is a Microsoft site afterall with plenty of SQL Server related advertising.
Except they forgot the none of the above choice. I don't use SQL Server as much as I used to (for job reasons), but for those that can't vote they either just don't vote or make up something and skew the results.
Paul Watson wrote: I don't use SQL Server. MySQL here.
|
|
|
|
|
Jeremy Falcon wrote: Except they forgot the none of the above choice
I thought that was what the 1 option was for, I ticked them all
|
|
|
|
|
Come on. You go hosting a data base on a crumpet, now you've got people porting the Linux kernel to crumpets, and all of a sudden you're surrounded by overweight penguins. Surely this isn't a good thing?
Software Zen: delete this;
|
|
|
|
|
Nope - muffins, the english type with big airholes you can fill with butter and tart rasberry jam....
As for crumpet - your not getting my DB on a crumpet.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
And this survey would have been a lot more interesting if you had included non-SQL Server DB's as well. And what about all the other flavors of SQL Server, like Express, CE, Compact...
Marc
|
|
|
|
|
OK, bad wording, and in the spirit of 'it's a pulbic holiday and I'm pretending not to actually be at work' I've nuked it.
Maybe next time I should (a) proof read, and (b) just reply with "Repost!"
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
Chris Maunder wrote: (b) just reply with "Repost!
I thought about that, and figured I'd do my usual Marc'ish behavior and go for the jugular. Shog9 was too polite.
Marc
|
|
|
|
|
I agree. I'd like do know how many people/companies/customers are using "SQL CompactEdition".
Also it would be interesting who is using MySQL, Oracle, Sybase, ...
|
|
|
|
|
SQLite is quickly becoming my favorite mini SQL DBMS. I just wish it had some more oomph in JOIN selects.
|
|
|
|
|
Im using ODBC & ADO.NET
Wormhole is the God divided by zero
|
|
|
|
|
And what my we ask is connect to the other end?
|
|
|
|
|
Norm .net wrote: what my we ask is connect to the other end
Maybe people?
You yell SQL queries at them and they throw sheets of data back at you.
|
|
|
|
|
Ah, the Soylent Green database.
|
|
|
|
|
I do that all the time, mostly to slow down the person making the request so they stop bugging me & learn that every question/task they give me they will be overloaded with queries (& I dont adhere to the timeout=3000000).
Would love to see a survey on who is using MS vs Non-MS databases (I understand there is a context in which you would make that decision to).
|
|
|
|
|
I have a bunch of monkeys on a few keyboards giving me my data.
He who asks a question is a fool for five minutes. He who does not ask a question remains a fool forever. [Chineese Proverb]
Jonathan C Dickinson (C# Software Engineer)
|
|
|
|