GilaMonster (11/10/2011)

---

derekr 43208 (11/9/2011)

---

So when a NC index is created, its leaf pages match the order of the data pages

No, no, no. Nothing whatsoever to do with the data pages....

Can this happen with a table with just non-clustered indexes on it.

Thanks

No, not at all. An index is fragmented if its pages physical order do...

GilaMonster (11/8/2011)

---

Fragmentation is solely and only a measure of how 'out of order' an index's leaf pages are based on the index key. That's all it is.

So if index X...

Thanks

I though that because the non-clustered indexes leaf pages have a pointer to the clustered index, if the Clustered index was fragmented, then NC index would also be fragmented.

Am I...

Thanks

Would that still apply even if the 2 indexes were covering the same columns?

Thanks

Thanks

If I have a table with a clustered index and a non-clustered index on it

If the Clustered index is fragmented, does that mean that the non-clustered index is also...

When using the not exists

Can my 1st select statement have a "where" clause in it before the "not exists"

I tried this

select name from sys.databases where recovery_model_desc <> 'SIMPLE'

and name...

Thanks

Ninja's_RGR'us (11/2/2011)

---

Looks fine but that's untested on my end.

I would possibly use not exists because it's clearer to me and it can't fail if a name is null. I...

Cool

Is my original script okay though? - To check which...

Ninja's_RGR'us (11/2/2011)

---

derekr 43208 (11/2/2011)

---

Would a maintenance plan...

Would a maintenance plan that deletes old...

Thanks

Evil Kraig F (11/2/2011)

---

Yep. It's the number of attempted inserts,...