Create index script for existing index

Question

Post reply

Create index script for existing index

SQL Galaxy

One Orange Chip

Points: 29420
More actions
April 18, 2011 at 6:15 am

#235799

Hi,

Recently Migrated SQL Server 2008 from old version SQL server 2000, also windows 2008 enterprise edition.

There is one data file (mdf) contain data & index which was already created in database.

1. I want to separate data. mdf and Indexfile .ndf file.

Once create index script file then create another file group for index after that execute the index script.

if drop the index (clustered-PK, non-clustered), Is there impact of database?

Could anyone share this script(url) for create index which is already created?

2. If SQL server 2008 enterprise edition 32bit on installed windows server 2008 enterprise Edition 32bit operating system, which are the mandatory points consider at OS level? like instance file installation and paging memory, please give me tips how to initiate these concept at OS level?

Thanks

ananda

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 1

you can create indexes script by the help of Generating Scripts

Right click on the desire database and then click TASK then click Generate Scripts,Select all tables then generate only indexes script

when you get all index script then add a new file group then add new file in this newly added file group then create indexes on this file group

Tell me about these

Total CPU physical and logical

Total RAM

Total Drives

is Clustered Mode

is this only Database Server or providing other services also

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com

SQL Galaxy One Orange Chip Points: 29420 More actions · Answer 2

Thanks for reply... Can we possible PK index on other filegroup?

1. Total CPU physical and logical

4 CPU

2. Total RAM

4GB

3. Total Drives

5 Drives - RAID 5

4. is Clustered Mode

No clustred mode

5. is this only Database Server or providing other services also

Other service running on SSAS, SSRS, SSIS.

thanks

ananda

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 3

PK understanding is PRIMARY KEY and if you see prefix like PK in a table indexes then its mean table have a PRIMARY KEY with clustered Index.when we create a primary key in a table then clustered index create by default

Yes you can create 1 Clustered index and 999 non-clustered indexes in a table and this table should have a schema and then this schema should have a file group

You can create a new Index Filegroup and then add a file or files in this group as you want then define this filegroup name in the index script or statement

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

My Blog
www.aureus-salah.com