What are page splits? | SQL Server Interview Questions

Pages are contained in extent. Every extent will have around eight data pages. But all the eight data pages are not created at once; it's created depending on data demand. So when a page becomes full it creates a new page, this process is called as "Page Split".

0 comments:

Post a Comment

Blogger news