Hi all, I am trying to create application which would have huge amount of data to be inserted and selected, and i am very new to SQL server in that case to database concepts........and now i need to create a database which can offer me a fast and accurate retrieval of data. please suggest me the perfect way of database design i mean how the tables are to be created --- say the concepts that are followed while creating the tables and database. Thank you
Read: Pro SQL Server 2005 Database Design and Optimization by Louis Davidson, Kevin Kline, and Kurt Windisch
We cannot suggest a "perfect way of database design", because we don't know the exact requirements. But you have a big challenge ahead to create a good performing database and application while being new to the whole topic. Good luck!
