People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that both have their uses, and it’s easy to find examples where either one is quicker. In this article, Phil Factor explains the main factors involved in choosing one or the other, and demonstrates a few simple ‘rules’ to get the best performance.  Read more...

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.  Read more...

This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.  Read more...

Last month, Phil Factor caused a furore amongst some MVPs with an article that dared to suggest that for reasonably small-scale strategic uses, and with a bit of due care and testing, table variables are a "good thing". Not everyone shared his opinion.  Read more...

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.  Read more...

Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.  Read more...

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.  Read more...

Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.  Read more...

Understanding the types of tables available in SQL Server can greatly enhance your database development experience.  Read more...