Question 134
DP-300 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention. You need to resolve the performance issues. What should you do?
- AImplement memory-optimized tables.
- BRun the DBCC FLUSHPROCINDB command.
- CReplace the sequential index keys with nonsequential keys.
- DRun the DBCC DBREINDEX command.