3 ms·
I found it to be heavy on resources, slow to respond and lets not forget cost What are you comparing it to? Admittedly I am biased since my day job is a SQL S
by timwiseman 15y ago
I found it to be heavy on resources, slow to respond and lets not forget cost
What are you comparing it to?
Admittedly I am biased since my day job is a SQL Server DBA, but I have tried several other options and think SQL Server tends to stack up quite well.
I have found it generally more user friendly, easier to work with, and cheaper than Oracle (though Oracle does seem to have an advantage in certain types of partitioning). I rather like MySql for certain types of projects, but generally find SQL Server easier to maintain for large projects.
I have only dabbled with NoSQL options, but my general opinion is that for certain problem sets, they are great. However, when ACID is even remotely desireable they are not an option and for certain other tasks they are less desirable.
So, I think that which type of database you use depends largely on the project, but SQL Server tends to stand up quite well for a wide array of projects.
- krmmalik 15y agoI was comparing to MySQL and PostgresSQL, although i can understand that it may not necessarily be a like for like comparison. Ultimately, i agree with what you are saying and my opinion of SQL server has improved in the last few months. I really like its flexibility.