Understand, but this is an "English" format here. 🙂

Great final article, and I saw that you did include the relatively new INCLUDE clause for indexes (2005) as you had said you were going to do in the Part...

Hmmm, the link is there at the bottom of Part 2 though. Anyway, sorry about that.. Also, I never meant to say that every column should be covered in every...

Very good series on the basics of indexes. Unfortunately, I was not able to read Part 3 as of yet since there seems to be an error on the web...

Alexander Kuznetsov-291390 (11/10/2009)

---

I decided that I don't want to put it into production - they are just a little bit too complex and they do not look robust to me....

Yes, thanks for the url though. I know, it's called a type-o. 😉 You would think that reversing the page order of the index...

Good article Jeff, and I did read Pauls blog on DBCC PAGE AND DBCC IND and Paul says the following about those undocumented commands:

"Before jumping into how things work, I'd...

Wilfred, I don't mean to sound picky or anything but the correct word occuring...

SQL Noob (11/9/2009)

---

i do db shrinks on archive databases once in a while to clear up space or to delete unused data files. otherwise i always create data files to...

Peter Gadsby (11/9/2009)

---

That is very weird behaviour....

Mind you I never understand why there is a requirement to shrink databases anyway. To my mind you should size the database correctly in...

Also, keep in mind that shrinking your database can often defrag your indexes badly negating the benefits of rebuilding then, which is yet another reason you should never set AUTO_SHRINK...

Very good point Paul! The three queries (yours, his singleton query, his query inside his index script which BTW he got out of BOL :)) all return different values in...

Then please let me rephrase that. The logical fragmentation column percentage in that dm function is not incorrect as much as it is irrelevant for small b-tress (small...

I got the same thing you did after executing your query script in my AdventureWorks2008 db before and after executing your indexing script and I also got the same thing...

No, you cannot select on just that dummy column, because if you read the original article he placed the DENY on that specific column with this statement:

DENY SELECT ON OBJECT::...