SQL Server Architecture Question:
Explain What are Page Splits?
Answer:
When there is not enough room on a page for a new row, a Server splits the page, allocates a new page, and moves some rows to the new page
| Previous Question | Next Question |
| MS SQL Server architecture Job Interview Questions! | Do you know what is RAID and what are different types of RAID configurations? |