⟩ Explain What are Page Splits?
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
Question and Answer:
Home MS SQL Server Architecture
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What's SQL Server?
Do you know how to configure DB2 side of the application?
Explain what is RAID and what are different types of RAID configurations?
What is CREATE DATABASE syntax?
What are the steps you will take to improve performance of a poor performing query?
But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%?
Explain what are the steps you will take, if you are tasked with securing an SQL Server?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What kind of LAN types do you know?
