SQL Server Architecture Question: Download MS SQL Server Architecture PDF
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? |