Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

What is SQL Server not good at?

By Steve Jones,

I was reading a post that had this quote: " The MongoDB docs tell you what it’s good at, without emphasizing what it’s not good at. "

This isn't to pick on MongoDB, but the post did make me wonder what things SQL Server isn't good at? Should our docs, BOL specifically, have warnings about scenarios where there might be problems with code? In addition to the remarks section, should there be "Warnings" section about various features, functions and code? I image that the CREATE FUNCTION page might have some warning about scalar UDF performance in many situations, and I'm sure many of you would think of warnings that might be added for other features.

I understand Microsoft might not like to point out flaws, but in the interest of building better code and applications, shouldn't various versions of BOL, and perhaps all docs, warn the client about potential issues with using a feature in a certain way? Documenting the potential problems with using a feature in particular situations isn't a flaw; it's guidance about how misuse might introduce other issues.

It's not likely that we'll start seeing more warnings in the official documentation, but for those of you that would like to improve the situation for others, there are always the "Community Additions" sections on all BOL pages. I don't know if Microsoft would post your warnings there, but if they allow them, we might be able to help others understand the pitfalls of using a particular technique.

Total article views: 335 | Views in the last 30 days: 1
Related Articles

What Is the Hardest Feature to Learn About SQL Server?

SQL Server is a complex product and many of us work with only a small part of the product. However m...


Other Questions about BULK_INSERT

Other Questions about BULK_INSERT


Are you a DBA? You might Be!

 Are you a DBA? You might Be! On Twitter, people do a lot more than gossip and post messages about ...


Hidden SSIS Features: Word Wrapping Your Annotations And More

Provides undocumented adjustments to package XML to enable Annotation Word Wrapping and other featur...


A Little Feature Self-Deprecation

The buzz started yesterday, with the rumblings about Database Mirroring showing up on the "Features ...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones