Edited later: inserted script and corrected results both for clustered table and table with non-clustered index

------------------

Thanks!

Let me understand

5)

how is IAM used on clustered table (or any table with any...

Context of SQL Server (for ex., 2008 R2), desirably other mainstream RDBMS

I am asking myself in order to understand docs (msdn articles, posts, BOL, etc.) as well as...

Thanks.

It is not hard but where is it written?

BTW, can you give definition of index?

I asked for this but had not got clear formulation, just round-about...

This is the essence of this post, my main question...

I am on SQL Server 2008 R2.

And, well, I reproduced results a dozen times already

4-lines output from Script 2) is:

PageFID PagePID IAMFID IAMPID ...

I just executed the script from mentioned "Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back", up to first command...

I prefixed my question in original post with numbers.

They are now 1), 3), 4).

Thanks for references but I am (also or more) concerned about the questions on how to use and interpret the output of "dbcc page()" and dbcc ind()", i.e. my other...

thanks.

I did not understand before your answer that I should mark unchecked checkboxes in order to unsubscribe

(and then press button).

I thought that if checkboxes are unmarked, then I am...

I could not find any "feedback on this site".

Why am I receiving Email notifications on the replies to this thread

if I unsubscribed from any previous notifications to forums or posts...

IMO, this is obvious and very annoying bug

which I reported

https://connect.microsoft.com/SQLServer/feedback/details/566945/bids-inserts-fanthom-code-page-s-into-ssis-2008-r2-components-irrelevant-to-format-locales-codepages-of-data-and-software-used-blocking-the-ssis-tasks

No, response whatsoever in 2 weeks

I guess from my previous experiences with ingenuous "conveniences" in MS products,

it will...

Congrats!

What was the distribution of questions (numbers or %) by topics (sections/areas)?

having same in the same SSIS package

I also would like to understand where is the phantom codepage for and why