<div>
Did you try <a href="http://msdn.microsoft.com/en-US/library/ms188365(v=sql.105).aspx" rel="ugc">BULK INSERT</a>? It's a faster way to insert data in tables.
</div>


Did you try BULK INSERT [http://msdn.microsoft.com/en-US/library/ms188365(v=sql.105).aspx]? It's a faster way to insert data in tables.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have table that contains data that is updated daily. &nbsp;Each night a job runs that truncates the table and then inserts a new set of values.<br />
<br />
The insert statement takes a few hours to execute.<br />
<br />
At the moment the table is empty for those few hours. &nbsp;Other applications that run during the day select data from the table - so its important that everything is completed during the night.<br />
<br />
I was wondering what would be the effect of putting everything in a transaction. &nbsp; &nbsp;Would the table appear to contain data all the time, or would it be empty during the period the transaction was commited?<br />
<br />
Is this a good idea?<br />
<br />
A second thought would be to use merge. &nbsp; Would the table always appear to contain data. Is this a good idea?<br />
<br />
/richard
</div>
</div>


Hello,

I have table that contains data that is updated daily.  Each night a job runs that truncates the table and then inserts a new set of values.

The insert statement takes a few hours to execute.

At the moment the table is empty for those few hours.  Other applications that run during the day select data from the table - so its important that everything is completed during the night.

I was wondering what would be the effect of putting everything in a transaction.    Would the table appear to contain data all the time, or would it be empty during the period the transaction was commited?

Is this a good idea?

A second thought would be to use merge.   Would the table always appear to contain data. Is this a good idea?

/richard

Transactions

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.