A new record | Rickard Andersson

A new record

As software applications that use SQL databases grow in functionality, so do the number of tables they use in the database. Not necessarily because they store more data but because they store more kinds of data. I believe PunBB, at least at the time I was working on it, had 17 tables. Microsoft’s App-V uses 46 tables. Ladok, the national system used for documentation of academic information at higher education institutions in Sweden, has 337 tables. But today, I almost fell out of my chair when I opened the database for CA Service Desk Manager, the service desk application we use in university IT. It has 2865 tables and 1388 views! Somebody likes to normalize their data.


  1. Posted July 16, 2010 at 16:03 | Permalink

    What? 2865 tables? So many tables means many subs-systems that I can’t imagine… :)

  2. Stuart
    Posted July 30, 2010 at 21:59 | Permalink

    I’d say look at it’s efficiency. Perhaps it’s a table #1 (firstname), table #2 (lastname) kinda deal! ;)

  3. Posted May 31, 2011 at 22:40 | Permalink

    Hey Rickard! I found your website while troubleshooting a Mac server video issue (oddly enough) and began reading your blog. Looks like you stopped writing here a year ago. Kids will do that to you. I hope that the baby and the wife are doing well. Would love to see more posts sometime.

  4. Posted May 31, 2011 at 23:16 | Permalink

    Kids will indeed do that to you :) Apart from having a son, I really don’t have an excuse for not writing anything. Your comment is duly noted.

  5. Posted August 15, 2015 at 23:05 | Permalink


    I did a search on your name as it appears at the bottom of the CHORDIE page and was wondering if that’s you?

    If so, I would like to express my appreciation for giving this ol’ fart a place to hang out with other guitarists. It’s really very kind of you!

    If I’m mistaken, please excuse me. I have no earthly idea of what you’re writing about up there.

    All the best!

    Bill (“Strummerboy Bill” on CHORDIE)

  6. Posted March 16, 2019 at 00:14 | Permalink

    If some one needs to be updated with latest technologies therefore he must be pay a visit this web page
    and be up to date daily.

  7. Posted April 10, 2019 at 13:27 | Permalink

    I visit day-to-day some web sites and information sites to read articles, however this blog presents feature
    based articles.

  8. Posted April 29, 2019 at 10:07 | Permalink

    Enviei um e-mail para Facebook há quase um mês.

  9. Posted May 5, 2019 at 18:11 | Permalink

    I think everything posted was actually very reasonable.

    However, think about this, suppose you typed a catchier title?

    I mean, I don’t want to tell you how to run your website, however what if you
    added something that grabbed folk’s attention? I mean A
    new record | Rickard Andersson is kinda boring. You should peek
    at Yahoo’s home page and see how they create post titles
    to get people to click. You might try adding a video or a picture or two to grab
    people interested about what you’ve got to say. In my opinion,
    it would make your website a little bit more interesting.

  10. Posted May 16, 2019 at 19:23 | Permalink

    Magnificent site. Lots of useful information here.

    I’m sending it to some buddies ans also sharing in delicious.
    And naturally, thank you to your sweat!

  11. Posted May 17, 2019 at 21:53 | Permalink

    Real clear website, appreciate it for this post.

  12. Posted May 23, 2019 at 14:54 | Permalink

    Its fantastic as your other posts :D, regards for putting

  13. Anonymous
    Posted June 29, 2019 at 21:19 | Permalink


  14. Posted July 2, 2019 at 06:23 | Permalink

    Hurrah, that’s what I was searching for, what a stuff!
    existing here at this webpage, thanks admin of this site.

  15. Posted July 4, 2019 at 11:57 | Permalink

    Migliori Lavatrici con Carica Frontale – Classifica e.

  16. Posted July 4, 2019 at 15:32 | Permalink

    We are a gaggle of volunteers and starting a new scheme in our community.
    Your site provided us with useful information to work on. You have done an impressive job and our whole
    neighborhood will probably be thankful to you.

  17. Posted July 4, 2019 at 15:42 | Permalink

    Thank you for another informative blog. The place else
    could I am getting that kind of info written in such a perfect means?

    I’ve a project that I am just now working on, and I’ve been on the glance out for such

  18. Posted July 4, 2019 at 15:59 | Permalink

    Can I simply just say what a comfort to find someone that actually understands what they’re talking about on the internet.
    You definitely understand how to bring a problem to light and make it important.
    More people ought to check this out and understand this side
    of your story. I was surprised that you are not more popular because you definitely have the gift.

  19. Posted July 4, 2019 at 15:59 | Permalink

    Everything is very open with a really clear description of the issues.
    It was really informative. Your site is very useful. Many
    thanks for sharing!

  20. Posted July 4, 2019 at 16:15 | Permalink

    Hi there it’s me, I am also visiting this site daily,
    this web page is truly pleasant and the visitors are in fact sharing nice thoughts.

  21. Posted July 7, 2019 at 23:50 | Permalink

    Bathing Suits
    Fast forward 2 years, girlfriend crushes my heart. I look on instagram
    and that girl is going through breakup too.
    I comment on her picture, which was a quote about breaking up.
    She adds that the way her autistic child is often treated is difficult to deal with.
    People love and are loved, they have unique interests and dreams,
    just like anyone, she says. Don treat my son as an object of fear or pity.

    Sexy Bikini Swimsuit The Uighur language is totally unrelated to Mandarin it is of Turkic origin and closely
    related to Uzbek, as well as Kazakh and Kyrgyz. Most Uighurs speak it
    as their first language. However, all official business must
    be done in Mandarin and all the signs are written in Chinese largest, with the Uighur translation written smaller underneath.
    Sexy Bikini Swimsuit

    Bathing Suits Aggressive and negligent drivers really rely on this luck to survive.
    Anytime I in a car with one, I count the amount of times we could have been in an accident if
    something were to unexpectedly happen. Like if something causes an sudden stop for the car in front while the my driver is tailgating.
    Bathing Suits

    wholesale bikinis However, the reality is not always so delicate, either in appearance or substance.

    In real life, when lightning hits sand that contains silica or quartz,
    the 1,800 degree Celsius (3,272 degrees Fahrenheit)
    heat travels underground and melts the sand into silica glass.
    The glass, known as fulgurite, is hollow and usually takes on a
    tube like shape, often with branches radiating out from a central core.
    wholesale bikinis

    bikini swimsuit These forward looking statements are
    subject to risks and uncertainties and involve many factors
    that could cause actual results to differ materially
    from those expressed or implied by such
    statements. Additional information on these risks and uncertainties can be found in our public filings with the Securities and Exchange Commission. IRobot undertakes no
    obligation to update or revise these forward looking statements, whether as a result
    of new information or circumstances.. bikini swimsuit

    beach dresses The notion of having all 13 episodes at one time,
    particularly in serialized storytelling, is very appealing.”[63] Loeb also added that the four characters chosen “all had a previous existing relationship and all grew up on the same kind of stoop
    in New York [in the comics]. So it lent itself to a world.
    Does that mean these shows are going to be the same? No.
    beach dresses

    Women’s Swimwear I think adding more chain 400 ms lights may
    make the differences between characters slightly blurry,
    and if possible, I like to avoid it. Not exactly sure what else could be done, though.
    One of my ideas was to let Nobushi kick after a chained
    heavy feint so that she has slightly more power in her chains,
    but I honestly doubt that would do much. Women’s Swimwear

    one piece swimsuits In 1988, Liz Hurley appeared briefly in a speaking part as a schoolgirl
    in “Last Seen Wearing”, an episode of the detective series Inspector Morse, which
    episode was partly filmed in a real school, Reading Blue Coat,[29] Sonning, Berkshire.
    This is believed to have been her first TV role.
    In the late 1980s, Hurley portrayed the title character in a five part
    television drama, Christabel. one piece swimsuits

    Women’s Swimwear Beyond its core product line the brand
    also features the extensions PrimaDonna Twist
    and PrimaDonna Swim (introduced in 2014). The Marie Jo brand meanwhile has its strongest consumer base in Northern Europe and
    has improved its performance during the second half of 2013, when a
    better resonating collection was available.
    Its brand extension Marie Jo L’Aventure has suffered somewhat from declining
    sales though. Women’s Swimwear

    Tankini Swimwear So, I stopped fishing. As for pain. Well, fish that are exposed
    to discomfort (in the article I read they used electric shocks) avoid it.

    I had mine done on the 22nd. It was laparoscopic.

    My tubes were cut then cauterized several inches.
    How is Natsukawa different from other Japanese supermodels?Jun is a little different from some of the other Japanese supermodels
    in the sense that she has released lots of photo collection DVDs instead of actual videos.
    In 2003, she worked with the Pyramid Art House and soon after that, her first photo DVD “Believe”
    was released. Her two latest photo DVD releases
    as of this writing are Naturally in 2007 and Breeze in 2008 Tankini Swimwear.

  22. Posted July 8, 2019 at 07:39 | Permalink

    Thank you for any other wonderful article. Where else may anyone get that type of info
    in such an ideal way of writing? I’ve a presentation subsequent week, and I am at the search for such information.

  23. Posted July 12, 2019 at 14:01 | Permalink

    Right here is the perfect webpage for everyone who would like to
    find out about this topic. You understand so much its
    almost hard to argue with you (not that I really
    would want to…HaHa). You definitely put a new spin on a topic that’s been discussed for many years.
    Excellent stuff, just wonderful!

Post a Comment

Comments are moderated. Your email is never published nor shared.