What is the capacity leaf node can hold?"

Posted by Oswaldlily under Sql Server on 8/1/2012 | Points: 10 | Views : 2619 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

when leaf node gets full,database server creates new leaf node and
move part of its contents to newly leaf node.

My doubt is "At what point leaf node gets full.?and
What is the capacity leaf node can hold?"

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 9/29/2012 [Member] [MVP] Bronze | Points: 25

0	hi refer this http://www.sqlservercentral.com/Forums/Topic997267-391-1.aspx#bm997271 http://stackoverflow.com/questions/10694894/find-all-leaf-node-records-using-hierarchyid http://use-the-index-luke.com/sql/anatomy/the-leaf-nodes Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

hi
refer this


http://www.sqlservercentral.com/Forums/Topic997267-391-1.aspx#bm997271 

http://stackoverflow.com/questions/10694894/find-all-leaf-node-records-using-hierarchyid 

http://use-the-index-luke.com/sql/anatomy/the-leaf-nodes

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/29/2012 [Member] [MVP] Bronze | Points: 25

0	hi Please mark as answer if it helpful to you. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts