There are two things data pages and index pages. So we have 8 KB data pages and 8 KB index pages. Page split only occurs for Index pages. For data pages it is but obvious that we need that many data page split. Think if we have 1 clustered index and 10 non clustered index we will have 11 page splits probably.
Page split when we mean its only for clustered and non-clustered indexes.Data pages split is just split and not page splits as such.
Answer (2)
Rampath Shinde
There are two things data pages and index pages. So we have 8 KB data pages and 8 KB index pages. Page split only occurs for Index pages. For data pages it is but obvious that we need that many data page split. Think if we have 1 clustered index and 10 non clustered index we will have 11 page splits probably. Page split when we mean its only for clustered and non-clustered indexes.Data pages split is just split and not page splits as such.
Guru
Thank you for this answer it really helped me