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.