<div>
What type of index, clustered or nonclustered? &nbsp;If nonclus, did the table already have a clus index?
</div>


What type of index, clustered or nonclustered?  If nonclus, did the table already have a clus index?

<div>
It was a non clustered index I created and dropped. &nbsp;The tbl already had a clustered index that is still there.
</div>


It was a non clustered index I created and dropped.  The tbl already had a clustered index that is still there.

<div>
I mis spoke before. It was a non clustered index. &nbsp;The tbl already had a clustered index that is still there.
</div>


I mis spoke before. It was a non clustered index.  The tbl already had a clustered index that is still there.

<div>
How big is the table (size in GB)?<br />
Are you performing a simple INSERT command or you're performing a massive insert?
</div>


How big is the table (size in GB)?
Are you performing a simple INSERT command or you're performing a massive insert?

<div>
<div class="content wysiwyg-content">
I created an index on a tbl w/ 3.5 million rows. &nbsp;It was taking forever so I dropped the index. &nbsp;Now it's taking twice as long for the insert before I created and dropped the index. &nbsp;Any suggestions?
</div>
</div>


I created an index on a tbl w/ 3.5 million rows.  It was taking forever so I dropped the index.  Now it's taking twice as long for the insert before I created and dropped the index.  Any suggestions?

After dropping index,  load taking a long time.

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

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.