<div>
Table has only one cluster index. So you can create more than one non-cluster indexes.
</div>


Table has only one cluster index. So you can create more than one non-cluster indexes.

<div>
Sarabhai.... Why at this stage should i just stick with a non-clustered?<br />
<br />
PatelAlpesh... Yes I know you can only have one clustered indexes. While I am not a DBA I have creted 100s, maybe thousands of indexes. 
</div>


Sarabhai.... Why at this stage should i just stick with a non-clustered?

PatelAlpesh... Yes I know you can only have one clustered indexes. While I am not a DBA I have creted 100s, maybe thousands of indexes.

<div>
Because the clustered index is going to physically rearrange the data on disk this is going to take quite some time if your hardware isn't extremely robust.<br />
<br />
I would only do this offline.
</div>


Because the clustered index is going to physically rearrange the data on disk this is going to take quite some time if your hardware isn't extremely robust.

I would only do this offline.

<div>
Check this out:<br />
<br />
<a href="http://www.sqlservercentral.com/articles/Data+Modeling/72814/" rel="ugc">http://www.sqlservercentral.com/articles/Data+Modeling/72814/</a>
</div>


Check this out:

http://www.sqlservercentral.com/articles/Data+Modeling/72814/ [http://www.sqlservercentral.com/articles/Data+Modeling/72814/]

<div>
<div class="content wysiwyg-content">
SQL2005 &nbsp; &nbsp;I have a 25 gig ,100 million record table in my database without a clustered index. It has a index on the primary key that I want to change to a clustered index. <br />
<br />
Is this something I can do while I am online? Is there any pitfalls you guys can warn me about? &nbsp; 
</div>
</div>


SQL2005    I have a 25 gig ,100 million record table in my database without a clustered index. It has a index on the primary key that I want to change to a clustered index. 

Is this something I can do while I am online? Is there any pitfalls you guys can warn me about?   

Adding a clustered index to a 100 million record table

Windows Communication Foundation (WCF) is a tool used to implement and deploy a service-oriented architecture (SOA) to support distributed computing where services have remote consumers. It features a runtime and a set of APIs in the .NET Framework for building connected, service-oriented applications. Services typically have a WSDL interface (Web Services Description Language) that any WCF client can use to consume the service, regardless of which platform the service is hosted on. WCF implements many advanced Web services (WS) standards such as WS-Addressing, WS-ReliableMessaging, WS-Security, RSS Syndication Services, WS-Discovery, routing and better support for REST services.

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.