Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2012-11-30 : 14:46:59
|
| Hi guys, I have question, I am thinking to create a INDEX PARTITIONING on my table that has more than 30milliion records. I never done this before. I need your help. Question 1 = I already has clustered and non clustered index on this table. I can create Index Partition withoutdelete any index that i already have in my table, am i right?Question 2 = If above answer is YES, Here is my steps to create index. Right click on Index and hit New Index, Give and name and Hit add (which column should i add here) or i am goona skip add step and hit filter section, and use below query select * from MytableName where ServiceDate > '2004/01/01'Please guide me. Thanks for your help in advance. |
|
|
|
|
|
Index Partitioning Help