Jaa

What gives you trouble when learning SQL Server?

  • Artikkeli

I've written a few posts about some of the bigger topics in learning SQL Server.  Now I'd like to hear from you - is there a particular area that you have trouble learning, due to poor documentation, unclear understanding of what the particular technology does, etc.?  Please leave a comment letting me know what area(s) you would like clarification about, and I will work with some of the smart folks here to give a different perspective on it.

Comments

  • Anonymous
    April 25, 2011
    Several topics related to SQL Server internals: tempdb, locks, latches, memory clerks, data types behavior, etc. It would be interesting to have more information about the various performance counters, optimal values vs. secure intervals. Also topics like Design/Security/Maintenance Best/Wrong Practices should be expanded. I found lot of useful information on various MSDN blogs, however some of them became inactive as migration of people from one project to another, or of other natural causes. I feel that some continuity is missing, sames as some knowledge map reflecting what's in there, topics covered or that need to be covered, etc. When I'm learning a technology I try to cover following:
  1. how can I use it
  2. when should I use it?
  3. which are its limitations/advantages?
  4. what best/wrong practices?
  5. what's the recommended configuration?
  6. which are the best resources (e.g. examples, books, blogs )
  7. how can I reuses the knowledge in other domains?
  8. what's the vocabulary related to it?
  9. what standards, procedures exist in the field? I think that by answering these questions would be covered most of professional's needs. Sure, not everything needs to be covered in documentation, though topics like "how it works" should not miss. I'm highlighting this because lot of the knowledge floating on internet is presumed, an important part of it it's true, but there are also many false believes. I think it's in a vendor's interest to minimize the diffusion of such false believes.

  • Anonymous
    May 06, 2011
    Great ideas, thanks for sending these in.  I will be on the road for a couple of weeks, but I will start in on these when I get back.

  • Anonymous
    April 08, 2014
    another option you can learn sql by online free tutorial at javatpoint. www.javatpoint.com/sql-tutorial