SQL Server with Mr. Denny:

Temp Tables


November 1, 2010  11:00 AM

What a difference a temp table makes over a table variable

Posted by: Denny Cherry
SQL Server, Statistics, Table Variables, Temp Tables

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...

December 10, 2007  8:00 AM

Temp Tables, Table Variables, and CTEs

Posted by: Denny Cherry
CTE, SQL, T/SQL, Table Variables, Temp Tables

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...

November 30, 2007  8:00 AM

New Article: Tricks to increase SQL Server query performance

Posted by: Denny Cherry
Article, T/SQL, Temp Tables

I've published a new tip over on SearchSQLServer.com entitled "   Bookmark and Share     0 Comments     RSS Feed     Email a friend


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: