Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike_cochrane
Starting Member
1 Post |
 Posted - 2002-01-27 : 17:28:48
|
| I am frequently using table variables as a temporary store for large datasets and was wondering if the operations that I perform on them are logged in any way to the transaction log.I wouldn't expect so, but the transaction logs for the database seem to be growing quite a bit and there isn't anything else that really explains it. |
|
|
bruins72
Starting Member
1 Post |
Posted - 2002-02-01 : 14:49:32
|
| Table variables don't require as much log space as a temp table but do require some. From BOL "Transactions involving table variables last only for the duration of an update on the table variable. Thus, table variables require less locking and logging resources." |
 |
|
|
|
|
|
Table variables and transaction logs