Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

What is SQL Server not good at? Expand / Collapse
Author
Message
Posted Friday, November 22, 2013 1:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:30 AM
Points: 2,898, Visits: 1,795
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
Post #1516672
Posted Friday, November 22, 2013 2:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 10, 2014 1:48 PM
Points: 2, Visits: 13
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.

Post #1516688
Posted Friday, November 22, 2013 10:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 30, Visits: 267
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.
Post #1516869
Posted Sunday, November 24, 2013 9:52 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 4:28 PM
Points: 8,677, Visits: 9,203
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
Post #1517099
Posted Sunday, November 24, 2013 7:08 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:18 PM
Points: 36,938, Visits: 31,441
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1517146
Posted Monday, November 25, 2013 2:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 10, 2014 1:48 PM
Points: 2, Visits: 13
@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.
Post #1517178
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse