1) You have a web application that is querying Active Directory and SQL Server
and a particular page is running too slowly when more than 5 users hit the page.
What would you look at to try and improve performance? What techniques would
you use to diagnose the problem and troubleshoot it?

2) You have a select query that joins 10 tables in SQL Server, some with
several hundred thousand records. You've determined that this query is running
too slowly, what are some things you can do to try to improve performance of
that query?

3) A client has an web app developed by another company that makes several
calls to a database from several different pages. Users report to you that the
web server crashes every couple hours causing them to have to reboot it several
times a day. Knowing nothing specific about the application, what might be some
potential causes of this?

4) Discuss in technical terms some advantages and disadvantages of converting
an existing application built in a non-object oriented language into an
application with the same feature set built in an object oriented language. How
would you describe to a client who is not technically savvy what the advantages
and disadvantages are and why he or she should or should not spend money on such
a project?

5) Provide a detailed example of a situation you might encounter in a project
whereby it would be necessary to perform asynchronous processing. What are some
potential pitfalls of multi-threading that you might encounter along the way and
how would you work around them?