2011-11-15
2,149 reads
Table Variables
A Temporary Disagreement
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.
2011-11-15
3,225 reads
Local Temporary Tables and Table Variables
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.
2010-01-15 (first published: 2008-09-01)
28,460 reads
Blogs
Audit Columns
One of the easiest ways to collect information about table activity is to add...
Daily Coping 28 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Book Review: Lights Out
By Steve Jones
I have always been interested in GE since I was a kid. My best...
Forums
Adding a PRIMARY KEY CLUSTERED
Is there a T-SQL way to add the following to an existing table that...
Result set different after breaking up case expression in where
I'm back again with more dumb questions. This time I am dealing with refactoring...
Sending Locking Alert
I have 2 tables the first one holds the dbwait information(locks), and the second...
Ask SSC