Carrier Interviews

1) Database
Data Model a Security Database

1) Support Auditing
2) Support Archiving
3) UPSERT
4) Normalization

http://www.databasejournal.com/features/mssql/article.php/3739131/UPSERT-Functionality-in-SQL-Server-2008.htm

2) What are the concurrency issues faced on the database and app server side ? How do we resolve the same ?

3) Trannsaction Management on the App Server/Database side

4) Improve garbage collection performance
http://msdn.microsoft.com/en-us/library/windows/apps/hh994643.aspx
http://ashishkhandelwal.arkutil.com/csharp/how-to-improve-garbage-collection-performance/
http://www.codeproject.com/Articles/39246/NET-Best-Practice-No-Improve-garbage-collector

when should we be using finalize() method