You need to reduce the amount of time it takes to execute Proc1
Which code segment should you execute?
Which options should you recommend?
Which technologies should you identify?
Which data types should you recommend for each column?
You need to create a distributed partitioned view
What should you create?
Which code segment should you use to create the table?
Which T-SQL command should you recommend?
Which three code segments should you execute?