Let's carry out the following steps to add lots of questions to our database. This will allow us to see the impact of data paging:

1. Let's open SQL Server Management Studio, right-click on the QandA database in Object Explorer, and choose New Query.
2. In the query window that opens, add the following command:

EXEC Question_AddForLoadTest

This will execute a stored procedure that will add 10,000 questions to our database.

3. Press F5 to run the stored procedure, which will take a few seconds to complete.

Now that we have our questions in place, let's test out the current implementation.