Questpond Question and Answer
Answer Now
Our Courses List 1
- Interview Questions & Answers Series for C# .NET Fresher & Experienced
- Azure DevOps Tutorial for Beginners & Professionals
- Power BI Step by Step Tutorial for Beginners and Experienced
- C# Step by Step & QnA Series ( Freshers and Experienced )
- Learn Azure, Azure Fundamentals using AZ-900, AZ-303 & 204 Architecture and exam preparation and Docker and Kubernetes
- Learn MSBI STEP BY STEP, MSBI Interview Q&A, SQL Step by Step and SQL Interview Q&A Tutorial
- Amazon Web Services (AWS) Training Recordings
Our Courses List 2
- React with MVC Core using EF and SQL Server
- Angular With MVC Core Combo Package
- Learn C# Design Patterns, UML Diagrams, Software Architecture, MicroServices Architecture & Design pattern Training Recordings
- SQL Server Step by Step + SQL Interview Q&A Tutorial
- Learn Angular Step by Step + 55 Angular interview Questions and Answers
- Learn MVC 5 in 2 days, Learn MVC Core in 4 hours, MVC Core Training
- Learn Data Structure and Algorithm Step by Step
Our Courses List 3
Our Courses List 4
- Most Important Angular Interview Questions and Answers
- ASP.NET MVC Core Interview Questions and Answers
- MSBI Interview Questions with Answers
- Power BI Interview Questions & Answers
- PHP Interview Questions & Answers
- Learn SQL server step by step
- Learn MSBI Step by Step
- .NET(C#) fundamentals, .NET collections, Generics
- Learn Azure in Step by Step manner
- Learn Angular Step by Step
- Learn Design Pattern Step by Step
- AZ 204 exam preparation
- Azure fundamentals using AZ-900 Guide lines
- Learn Tableau Step by Step videos
- Learn Power BI step by step
- Python, R programming, Maths for Data Science
- Learn ReactJS & NodeJS(MERN) Step by Step
- Learn NodeJS Step by Step
Are you sure?
Are you sure You want to delete answer.
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