May 18, 2012 at 4:05 pm
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
May 18, 2012 at 4:12 pm
Evil Kraig F (5/18/2012)
I think I'll go re-read your blog a few times until it gets better stuck in my head. 🙂
That's not on my blog. It's stuff I've learned since writing that post.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2012 at 4:15 pm
GilaMonster (5/18/2012)
Evil Kraig F (5/18/2012)
I think I'll go re-read your blog a few times until it gets better stuck in my head. 🙂That's not on my blog. It's stuff I've learned since writing that post.
Hm, I pulled that number from ... somewhere... and yours is 4% actually for the one I was thinking of. It's out there somewhere, dangit.
I need to find it, I need to go...
TO THE CLOUD!
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
May 18, 2012 at 4:26 pm
Alright, I found where I pulled .3% out of ... the Aether... and realized why I'd done it.
For those interested, a more in depth discussion can be found here from Kimberly Tripp:
http://www.sqlskills.com/BLOGS/KIMBERLY/category/The-Tipping-Point.aspx
It's because the majority of tables I was working with at the time were in the range of 100 rows/page (give or take) and that number simply stuck to my head. Yawhoops. Sorry.
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
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply