MS hardly admits problems.
As a old joke said "...MS is a marketing corporation with serious software issues"
At forums and MSDN they often use the "its by design" or "its a normative variation" excuses.
IMHO MS SQL Server is by far the most reliable product from MS and today its a mature software full of usefull tools.
But if there are something its not good... maybe its not good for the small shop budget.
I work most with web development where MySQL and Postgre earn great popularity and MS SQL got a reputation of too big, and too expensive.
Maybe we can see more SQL Lite brands (for free) in the future.