Do you have the "Backward Compatibility" and "2005_DTS" add-ons installed ? What service pack of 2005 are you on ?

You can also use the Activity Monitor GUI, then look at details to see what's running.

Duplicate post in an old thread. Reply...

gk-411903 (12/21/2009)

---

Forgive my ignorance. I understand that the index is moved to the desired filegroup (index file group). But is the data also in the same index file group? I...

Instead of using the GUI locally on your desktop, use the GUI...

I seem to recall that you can get blocking when creating a table this way if...

Yes, prevent the duplicates in the...

Is "acad" the default database for those users ?

If MDF_2 is in the same file group then SQL will add to it outside of your control. If you create a secondary file group, then you can move tables...

Thanks for all the tips.

I just came across this on SQL-Performance, so I don't see a clustered Index in my future since the table is 1+ Terabytes:

"...Also keep in mind...

EdVassie (12/18/2009)

---

Changing one of the existing indexes to clustered may (or may not) cause maintenance problems in the future if you apply a service pack from your app supplier. ...

SMNayak (12/18/2009)

---

I had searched a lot for this...!!!

Finally got a one simple solution... 🙂

The user's windows login should be having the admin rights in the machine where the SQL Server...

vky3 (12/16/2009)

---

Hi All,

I have newly joined a company and here for a couple of servers we have the backups and the log files on the same drive. I...

This is a 3rd party application and it's always seemed odd that they don't have any clustered indexes.

Is there a downside or risk to me creating a clustered index...

GilaMonster (12/15/2009)

---

That's a problem. The heap can't be rebuilt, except by putting a cluster on it, and if there are pages partially used in the heap they'll stay partially used...