PrepAway - Latest Free Exam Questions & Answers

What should you do first to reduce the number of page splits?

You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
A server named ABC-SQL1 hosts an Online Transaction Processing (OLTP) database named
ABC-DB1. A table in ABC-DB1 has an index. You discover a high level of page splits when data
is updated in the table or when new rows are inserted.
You plan to recreate the index on the table.
What should you do first to reduce the number of page splits?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure a FILLFACTOR value of 60 in the index options.

B.
Configure a FILLFACTOR value of 100 in the index options.

C.
Configure STATISTICS_NORECOMPUTE = ON in the index options.

D.
Configure STATISTICS_NORECOMPUTE = OFF in the index options.

Explanation:


Leave a Reply