Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Partioning a table with non-clustered index but no clustered index

Status
Not open for further replies.
TheBugSlayer

TheBugSlayer

Programmer
Sep 22, 2002
887
US
Hello all.

We are considering partitioning a very large table mentioned in a previous post. The table has a few non-clustered indexes and no primary key. The best candidate column for partitioning has a non-clustered index defined on it. Can I partition the table on this column without having to create a primary key that encompasses it?

Thank you.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)
 
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
183
TheBugSlayer
TheBugSlayer
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
231
fredericofonseca
fredericofonseca
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
255
CodeWell
CodeWell
baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
212
iambob
iambob
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
202
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top