Google News
logo
SQL Server - Interview Questions
How can you ensure that the database and SQL Server based application perform well?
A developer must check type of information stored, volume of data and the data that will be accessed. 
 
* In a scenario, where you are upgrading an existing system, you should analyze the present data, existing data volumes occur, and check the method through which data is accessed, to help you understand the problem areas for design.
 
* In a scenario, where you are using a new system, you have to keep the information about what data will be captured, and what are the constituents of data, and the relationship between the data items.
Advertisement