You work for a manufacturing company. The company has recently hired a programmer who does not have knowledge of SQL Server, but has been tasked to develop -queries. As a database administrator, you have been tasked with the following to help him/her out with understanding queries and performance. Address the following -in your discussion posts:
- What design considerations will the developer need to be aware of to ensure queries are optimized? Why?
- What should the developer be aware of when sorting data in a result set? Why?
- Explain how you can test a prototype query to fine-tune its performance characteristics.