Click here to monitor SSC
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
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36344 Visits: 18752
Comments posted to this topic are about the item What is SQL Server not good at?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45434 Visits: 39942
The article link in the post above doesn't work. It takes me to a "Not found" window.

--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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16544 Visits: 13210
You can find the article in the daily newsletter. Can't find it on the site though.

What's SQL Server not good at?
SSRS and SSIS could certainly improve a lot in regards to usability. Especially SSRS lacks some very basic features, such as a decent configuration of prompts and even "justify text" is missing.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8413 Visits: 6176
I guess it could be a question of emphasis. Surely it would be to the advantage of Microsoft to give a greater impression of openness, clarity and helpfulness if they did highlight (particularly common) abuses and poor uses of various features especially if they offered explanations and alternative solutions.

Let's face it, when it isn't done the perpetrator of such implementations will often blame the tool (in this case SQL Server) instead of a misguided use of it i.e. "it can't be my [code/configuration/etc.] that's wrong it must be [SQL Server/SSIS/SSRS/.NET/etc.] that's rubbish".

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
amisrahi
amisrahi
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 49
I think the trouble is that with software, if you can properly state the problem you can usually state the solution in code. It means once you've properly identified a weakness you'll already be halfway to planning the solution. Would you prefer to own up to something people might not even have pinned on you? Or would you just rush to fix it and enjoy the praise for innovation when it's done?

e.g. One of the supposedly inevitable aspects of databases used to be that a lot of locking must occur. What's the solution to too many people and processes reading and altering the same bits of data? Err...don't.. At least find ways to make transactions really quick then keep your fingers crossed. READ UNCOMMITTED is what many still dangerously resort to because of this and even READ COMMITTED doesn't guarantee you consistent data from a given instant in time. Before 2005 do you imagine Microsoft were thinking 'Well, a mostly good solution would be to do like some other DBs and build snapshots in the background and query those". Of course they did but they didn't come out and make a big noise about how the paradigm was fundamentally flawed for high transaction environments. They bided their time till they could get Snapshot Isolation Level implemented. You'd do that yourself if it was your own program and you had pride in it. In a community of eagle-eyed users, you'd be desperate to fix quickly rather than do all the criticism for them.

Adam
Robert.Sterbal
Robert.Sterbal
SSC Veteran
SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)SSC Veteran (213 reputation)

Group: General Forum Members
Points: 213 Visits: 2000
I tend to rely on google and experience, as well as one on one interaction to address the issue that you raised here. It is the nature of the form of documentation that it is a bad place to put what the limitations are. Makes it too easy for competitors to attack your business.
Luis Cazares
Luis Cazares
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8584 Visits: 18158
Even if it's included in BOL, would people read the warnings?
Most people having bad coding habits won't even read basic documentation and go for what they suppose is better with no real bases.


Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8413 Visits: 6176
Luis Cazares (11/21/2013)
Even if it's included in BOL, would people read the warnings?
Most people having bad coding habits won't even read basic documentation and go for what they suppose is better with no real bases.


That is probably fair comment regarding a significant number, however, a lot of people do at the very least a little research around features that they are about to utilise, especially on new features or those last used a long time ago. I think it is an inadequate reason not to do it on the basis that most people will not pay any attention to it. It would be there for those of use who do read up. Thus marking as out as being different from the rest of the crowd. Otherwise BOL wouldn't exist either.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
jcb
jcb
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2742 Visits: 969
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.
steve_seeley
steve_seeley
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 47
To quote the favorite answer of technical people everywhere, "It depends". I can take a simple select statement and if I miss something in the where clause I can tank the server. Does that mean we should put warning signs all over? SQL Server is a tool. I can use a screwdriver to drill a hole but it won't be done neatly or easily. There are too many ways to misuse any tool and get bad results. While I do think that it is nice to know limitations or shortcomings sometimes I feel that I am better off not knowing.
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