• Double-checking a solution suggested by the more seasoned gurus on this or other sites is perfectly fine. If I run it on my own desktop, and it doesn't work, either there was a typo or error in remembering all of a table's or view's columns (for example, can you all name, off the top of your heads, what all the columns are when selecting from sys.dm_db_index_physical_stats(...)?). As long as the logic and spirit of the solution is sound, you can still be confident in that person's abilities.

    People being people, however, a bona fide mistake, an error in the logic, will eventually occur. Give the person the same professional feedback as they gave you and they should be grown up enough to say, "Oh! How did I miss that? Thank you."

    I can only imagine the discussions that Paul and his wife, Kimberly Tripp[/url], have when they catch each other's mistakes, rare as they may be. Eventually will want to make it to a SQL conference and see them both present the same subject. I've heard they're quite spirited. 😀

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein