GilaMonster (5/18/2012)
Evil Kraig F (5/18/2012)
Apologies for the confusion. Yeah, my numbers were off too, sorry, it's 0.003 or .3%... and I dropped it in the middle of the two, heh.No, it's not. It's usually around 0.5% of the table, but it is not a hard and fast % of the table. The most accurate calculation would be that the query tips around row count = 20% of total pages in the table.
Which may be where I confused myself. Thank you for re-clarifying. I think I'll go re-read your blog a few times until it gets better stuck in my head. 🙂
Where the heck did I pull 0.3% from? Goes digging....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA