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

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 into the different temporary tables types, there are good posts on these. I’m going…

0

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

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 on SQL Server. This means…

4