• Using table variables (or temp tables) to speed up… or slow down

    Posted over 2 years ago
    by Robert Hartskeerl}
    In SQL Server you can use temporary tables to store intermediate results. This is a common used technique to speed up query processing. Recently I came across a problem where the temporary tables were causing the performance degradation. I'm not going...

  • I got my MCM Lab result.... And I failed!

    Posted over 2 years ago
    by Robert Hartskeerl}
    A couple of weeks ago I got the result from my SQL 2008 MCM Lab exam and I failed. I have been working with SQL Server for almost 12 years. I have been a developer, dba and architect and last year I joined Microsoft to become a Premier Field Engineer...