1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain what are page splits? : SQL Server Architecture

Question Posted / nishant pal


Explain what are page splits? : SQL Server Architecture..

Answer / Rahul Shastri

"Page splits occur when a data page becomes full and there is an insert operation that does not fit in the existing page. The database management system will split the page into two halves, with one half containing the original data and the other half storing the newly inserted data."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1 Answers  

What are the essential components of sql server service broker?

1 Answers  

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

How to insert multiple rows with one insert statement in ms sql server?

1 Answers  

How do you delete duplicate rows in sql server?

1 Answers  

What is an expression in ms sql server?

1 Answers  

What is scheduled job and how to create it?

1 Answers  

What happens when converting big values to integers?

1 Answers  

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1 Answers  

Which sql server table is used to hold the stored procedure scripts?

1 Answers  

What are the four main query statements?

7 Answers   Wipro,

What is the stored procedure?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories