GilaMonster (9/9/2010)

---

Not sure I understand you.

Splitting the database into multiple files is not going to help performance if all the files are on the same physical drive. Doesn't matter where...

GilaMonster (9/9/2010)

---

If there's only one disk, then you have nowhere else to create the files and there's little point in doing so. There's little performance benefit from multiple files on...

Yes , i have create the file group. but it is on the same location...

hi,

Thanks for the reply.

how can i create the file group on normal disks? i m using the normal disk.

irobertson (9/1/2010)

---

Hi Grasshopper,

You're going to struggle to work with the file in the format it's in. SQL needs your data to be organised into discrete entities with rows and columns....

hi,

thanks for reply,

Is it possible to create the new file group on separate physical disk.how can we do that.

Hi,

Yes i have not create the indexes on these tables.

I m creating the indexes on these tables. then i will check the performance, if same problem exists then i will...

hi,

Sorry,

Now i have post the table script and the query to fetch the record.

data is not possible to Post here.

thanks

hi,

Thanks for reply.

i have post the script file.

NOW I UNDERSTAND THE LOGIC BEHIND IT.

Thanks Champ,