建议在SQL SERVER中使用全局临时表来存储事务记录吗？ [英] Is recomended to use global temp tables for storage transactional records in SQL SERVER?

问题描述

Hi everyone,

I need to storage a set of transactional records in a global temp table for a particular process, the total of records is near 2 millions and growing slowly.

The space of tempdb in my sql server is big (like 2TB) but the question is: what is recomended working with temporary tables for storage transactional tables.

What is it recomended for tempdb for this goal.

我尝试了什么：



我尝试使用SSIS在我的ETL项目中使用临时表。

我的所有任务。

What I have tried:

I try to working with temporary tables in my ETL proyect with SSIS.
in all of my task.

推荐答案

如果您在会话期间需要临时表，请使用临时表;会话结束后不需要保留它们。



快速概述：SQL Server 2005中的临时表 [ ^ ]

Use temporary tables if you need them during your session; and don't need to keep them once your session is finished.

Quick Overview: Temporary Tables in SQL Server 2005[^]

这篇关于建议在SQL SERVER中使用全局临时表来存储事务记录吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！