ok got it

0HEAP94.4444444444444178

2NONCLUSTERED INDEX87.58

3NONCLUSTERED INDEX87.58

4NONCLUSTERED INDEX83.33333333333336

5NONCLUSTERED INDEX85.71428571428577

6NONCLUSTERED INDEX85.71428571428577

7NONCLUSTERED INDEX87.58

8NONCLUSTERED INDEX9520

9NONCLUSTERED INDEX9520

10NONCLUSTERED INDEX94.736842105263219

11NONCLUSTERED INDEX94.117647058823517

12NONCLUSTERED INDEX93.7516

that's what i got it form a particular table.

here it is ---

0HEAP 96.7741935483871144

2NONCLUSTERED INDEX85.71428571428577

3NONCLUSTERED INDEX83.33333333333336

0HEAP...

more than 450 pages atleast

they are > 80%

can someone reply me please?

thanks a lot.

thanks i will try it out

so once again can someone answer please........

But that will create lot of fragmentation. and i think after that rebiulding idexes is not a good idea since that will take space,...

dude i know the product i am a DBA but i am a newbie and i was told to delete certain tables by my manager because those tables were already...

any comment on this friends?

But that will create lot of fragmentation. and i think after that rebiulding idexes is not a good idea since that will take space, so any idea how do i...

just right click the DB select --task---detach

move the mdf and ldf files

now right click on database--attach and now select mdf and ldf from the new location that you moved to.

that's...

Thankyou all for the suggestions. that's what i was thinking.

any ideas friends?