GilaMonster (10/5/2010)
Craig Farrell (10/5/2010)
I got it right, but a question regarding dedicated extents. I know page splits will happen, etc etc, but does an extent stay compact for a range of data, or will it split out of the extent and return to it with page pointers?Test it out and see (hint DBCC IND and DBCC PAGE)
Think about it. What happens if all 8 pages in the dedicated extent are full and a row is inserted that has to go onto page 4 of the extent?
Ah, DBCC IND, thank you, couldn't remember for the life of me. Stupid undocmented... mutter mutter.
It's going to go cross extent. Gyeah. For some reason I had though the extents shifted, keeping multiple page chains intact... and I check the extent alloc status and it's all over the place. Alright, I have some understanding on extents to do. My experience with them is limited to fighting with LOB data.
Which begs the question, why the heck are there extents in the first place for anything but LOB data...
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