SQL Server Architecture Question:

Download Job Interview Questions and Answers PDF

Explain What are Page Splits?

MS SQL Server Architecture Interview Question
MS SQL Server Architecture Interview Question

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

Download MS SQL Server Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
MS SQL Server architecture Job Interview Questions!Do you know what is RAID and what are different types of RAID configurations?