Performance
- Explain partitioning in SQL databases.
- Explain the NOLOCK hint and when it should be used.
- How do you handle deadlocks in SQL?
- How do you implement concurrency in SQL?
- How do you manage large datasets in SQL?
- How do you monitor performance in SQL databases?
- How do you optimize slow-running queries in SQL?
- How do you perform bulk inserts in SQL?
- What are database locks, and how do they affect queries?
- What is a query optimizer, and how does it work?