SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What is SQL Server not good at?


What is SQL Server not good at?

Author
Message
David.Poole
David.Poole
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7373 Visits: 3279
Depends what you regard as SQL Server.
1. The relational engine
2. The column store engine
3. SS IS/AS/RS
4. Full-text search

For me full-text search is disappointing. That is why people suck data out into Apache SOLR.
Having used Ab Initio I can say that SSIS isn't brilliant.

The question I have is whether you think SS IS/RS should be open-sourced?

For what you get the costs aren't as bad as they are made out to be. Open source is great on the community editions but you quickly reach the point where what you actually need is the Enterprise Edition in which case the costs are comparable and you have to factor in the additional effort to integrate everything.

LinkedIn Profile

Newbie on www.simple-talk.com
will 58232
will 58232
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 42
What is SQL Server not good at?

Defining constraints declaratively.

The CREATE ASSERTION statement has been in the SQL standard since 1992. Microsoft still haven't implemented it.

If you have a constraint that states "a department must not have more than its maximum number of employees" you currently have to write triggers on two different tables to achieve this.

With CREATE ASSERTION this constraint can be achieved with a single SQL expression.

As none of the other major SQL-DBMS vendors have implemented assertions, this would give Microsoft a major selling point.
ccd3000
ccd3000
SSC Veteran
SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)

Group: General Forum Members
Points: 210 Visits: 768
Absolutely. Over the last few years, it's one of the first questions I ask vendors about their products. To me it's similar to knowing when not to use my hammer for a given home improvement scenario. Salespeople will talk all day about how wonderful their product is, but if they can't tell me any of its weaknesses then I'm a little suspicious.
TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14150 Visits: 12197
There are a few failings that I find irritating:-
The inability to represent domain constraints directly. If I have some domain that is used in many coulumns and in many tables, I want to be able to declare that domain, name it, use the name in each of teh plances I want that domain. But I have to use a check constraint to define the domain instead, which means writing a constraint once for each place I use that domain.
The inability to handle general regular expressions, instead of the silly wildcard stuff for strings - and that compounts the domain issue.
All sorts of other things, but as it's an SQL based system I can't really ask for it to support the relational model, can I (eg why isn't there a symmetric difference operator).
Where is support for the latest floating point standard?
Where is support for the error management capabilities of the old floating point tandard that it claims to support?

I could probably go on,and make a longer list, but it wouldn't be useful.

On community comments, I think MS will happily publish them if they point out real issues; they don't seem to do much vetting of community comments, or pay much attention to them. I guess they might take notice and suppress something if it were illegal or thoroughly immoral or just an anti-microsoft rant rather than anything useful. But I've seen some quite idiotic comments that were allowed to stand, and also some quite anti-microsoft ones that raised real issues but in a pretty offensive manner, which suggests they are not excessively sensitive about what we add to their BOL pages.

As a general

Tom

Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)SSC Guru (84K reputation)

Group: General Forum Members
Points: 84429 Visits: 41061
ccd3000 (11/22/2013)
Absolutely. Over the last few years, it's one of the first questions I ask vendors about their products. To me it's similar to knowing when not to use my hammer for a given home improvement scenario. Salespeople will talk all day about how wonderful their product is, but if they can't tell me any of its weaknesses then I'm a little suspicious.


Oddly enough, I feel the same way about the T-SQL "hammer" that I use all day every day.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
will 58232
will 58232
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 42
@L' Eomot Inversé

support the relational model


Yes, that is something that SQL Server doesn't do well.

However the competitors are no better on this front.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search