Test type-safe conversion function performance

In the last two exercises, we looked at the TRY_CAST(), TRY_CONVERT(), and TRY_PARSE() functions. These functions do not all perform equally well. In this exercise, you will run a performance test against all of the dates in our calendar table.

To make it easier, we have pre-loaded dates in the dbo.Calendar table into a temp table called DateText, where there is a single NVARCHAR(50) column called DateText.

For the first three steps, the instructions will be the same: fill in missing values and keep track of the amount of time each operation takes. You will then summarize your results in step 4.

Fill in the correct conversion function based on its parameter signature.
Use a function to retrieve the number of milliseconds for each operation.
Fill in the blanks (in order of start time, then end time) and the date comparison function.

Take Hint (-7 XP)

Exercise

Test type-safe conversion function performance

Instructions 1/4