Temp Tables

What a difference a temp table makes over a table variable

I was working on performance tuning the data deletion process that I use to remove data from our database.  We delete massive amounts of data on a daily basis, so our data deletion process is pretty important to us.  As we've grown our customer base the amount of data to be deleted every day has...

Temp Tables, Table Variables, and CTEs

There are some major differences between temp tables, table variables and common table expressions (CTEs).  Some of the big differences are: Temp Tables vs. Table Variables

1. SQL Server does not place locks on table variables when the table variables are used.
2. Temp tables...

New Article: Tricks to increase SQL Server query performance

I've published a new tip over on SearchSQLServer.com entitled "