<div>
An index will not speed up the inserts, in fact, it may slow them down.<br />
<br />
If you need to index the table, insert the rows first and add the appropriate indexes later. &nbsp;If you need a clustered index, create the index and insert the rows in the order of the clustered index.
</div>


<div>
an index will slow down insert operations because the new records will need to be indexed. updates will also be a bit longer if you update fields part of the index<br />
<br />
but indexes will help your select statements if you have a WHERE clause that matches the fields you have indexed. Update and Delete statement can also benefits from indexes if the correct fields are used.<br />
<br />
to insert 1000 rows, just add &quot;GO 1000&quot; before your insert.
</div>


<div>
What does &quot;'huge&quot; means? 10 million rows?
</div>


<div>
yes, it's a million record table insertion<br />
<br />
<br />
<br />
how &quot;Go 1000&quot; before insertion?
</div>


<div>
I want the insert statment to insert/commit &nbsp;every 1000 each time until insert all records end.<br />
<br />
I google GO 1000, I don't find how to use it.<br />
<br />
LIke below<br />
<br />
GO 1000<br />
Insert into....<br />
select....<br />
from...<br />
where....<br />
<br />
Does it &quot;GO 1000&quot; can do this purpose?
</div>


<div>
have a look at <a href="https://msdn.microsoft.com/en-us/library/ms188037.aspx?f=255&MSPPError=-2147217396" rel="ugc">https://msdn.microsoft.com/en-us/library/ms188037.aspx?f=255&MSPPError=-2147217396</a><br />
<br />
the [count] parameter is your 1000
</div>


<div>
I want to know if the following code is equaivalent to GO 1000<br />
<br />
DECLARE @BatchSize INT = 10000<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHILE 1 = 1<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BEGIN<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Insert into....<br />
&nbsp; &nbsp; &nbsp; &nbsp; select....<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;from...<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; where....<br />
<br />
<br />
&nbsp; &nbsp;IF @@ROWCOUNT &lt;&nbsp;@BatchSize BREAK<br />
&nbsp; &nbsp; <br />
END
</div>


<div>
@@ROWCOUNT will always be 1 in your case because it is reset for every loop
</div>


<div>
I just made a test, the GO goes after the statement to repeat. Try it with this:<br />

<pre><code class="code-1 nolinks" id="code-20-41827351-1"><span>SELECT GETDATE()</span>
<span>GO 10</span>
</code></pre>
</div>


<div>
what do you mean &quot;@@ROWCOUNT will always be 1 in your case because it is reset for every loop&quot;?<br />
<br />
How to fix it?<br />
<br />
Your code<br />
SELECT GETDATE()<br />
GO 10<br />
<br />
will be equal to my code in funtionanity?
</div>


<div>
if you mean to use the system variable @@rowcount after the insert statement in a loop, after each insert statement the value of @@rowcount will be 1 because it is returning the number of rows affected by the last statement (your insert in your case) and not the total number of rows into your table. Check <a href="https://msdn.microsoft.com/en-us/library/ms187316.aspx?f=255&MSPPError=-2147217396" rel="ugc nofollow">https://msdn.microsoft.com/en-us/library/ms187316.aspx?f=255&MSPPError=-2147217396</a>
</div>


<div>
If I want to insert total number of rows into my table,<br />
<br />
what @@ROWCOUNT &nbsp;value will be?
</div>


<div>
the number of rows you have inserted
</div>


<div>
I want to insert all rows into a table. I don't know exact how many rows
</div>


<div>
With all those comments, you pick your own final comment as deserving of <i>all</i> the points? &nbsp;Seriously??
</div>


<div>
<div class="content wysiwyg-content">
I have a table. I want to insert a huge records into it. For fast performance, I want to know if I should set up an index, is better or completely no index is better?<br />
<br />
How to have a script to commit 1000 records each insert from the folowing script format<br />
<br />
insert into...<br />
<br />
select....<br />
from...<br />
where...
</div>
</div>


I have a table. I want to insert a huge records into it. For fast performance, I want to know if I should set up an index, is better or completely no index is better?

How to have a script to commit 1000 records each insert from the folowing script format

insert into...

select....
from...
where...

indexed table vs unindexed table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.