<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hey Guys,<br />
<br />
I am a relatively new programmer, and i have built a very large table in one of our databases. The size is around 4 billion records, so as you can imagine performance has been slow. I would like to properly index this table, however i got an error message when executed a query that should have implemented a clustered index and ran for 13 hrs. <br />
<br />
any and all advice is welcome,<br />
<br />
CJ
</div>
</div>


Hey Guys,

I am a relatively new programmer, and i have built a very large table in one of our databases. The size is around 4 billion records, so as you can imagine performance has been slow. I would like to properly index this table, however i got an error message when executed a query that should have implemented a clustered index and ran for 13 hrs. 

any and all advice is welcome,

CJ

SQL Management Studio - Indexing Help

Content management (CM) is a set of processes and technologies that supports the collection, managing, and publishing of information in any form or medium. When stored and accessed via computers, this information may be more specifically referred to as digital content, or simply as content. Digital content may take the form of text (such as electronic documents), multimedia files (such as audio or video files), or any other file type that follows a content lifecycle requiring management.

Content Management

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.