Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
java148
Yak Posting Veteran
63 Posts |
 Posted - 2011-12-15 : 23:55:51
|
| In the index structure, it only has three levels: root, intermediate and leaf level, no matter how many pages. my understanding is correct ?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-16 : 06:52:28
|
| Nope. Root, 0 or more intermediates and then the leaf pages. Larger the index, the deeper it'll be and the more levels of intermediates there will be.--Gail ShawSQL Server MVP |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-12-16 : 07:20:33
|
| http://blog.sqlauthority.com/2009/12/16/sql-server-fillfactor-index-and-in-depth-look-at-effect-on-performance/Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
index structure