Forum Replies Created

Viewing 9 posts - 31 through 39 (of 39 total)

  • RE: dbcc

    Thanks

  • RE: filegrowth

    Thanks peterhe. But you did not explain what the nature of the overhead in allocating additional disk space is. Why is there overhead? What is involved in allocating additional space?

  • RE: Address of extents in an IAM

    Thanks for your answers, Carl. I will try getting the book.

  • RE: B Tree Indexes

    Thanks a lot, Scott. The webcasts you mentioned are quite interesting. I really appreciate your help.

  • RE: B Tree Indexes

    Thanks very much Scott. I see your point. In fact, I found a flaw in my own reasoning. Since data pages have to be there anyway, it's basically a question...

  • RE: B Tree Indexes

    Thank you, Scott and Chris. Scott: You mentioned that the size of a clustered index is not larger than the combined size of a corresponding non-clustered index and the data...

  • RE: Tables and Indexes

    Thank you, Chris. Could you also clarify one more thing? When I was reading the database book by Elmasri, I learnt that B+ Tree indexes at their leaf level have...

  • RE: Tables and Indexes

    Just need one clarification if you will. The leaf level of a clustered index: is it said to be made of data pages or index pages? In Oracle, for example, there...

  • RE: Tables and Indexes

    Thank you Steve and Peter. I really appreciate it.

    Karim

Viewing 9 posts - 31 through 39 (of 39 total)