86 reputation
3
bio website
location
age
visits member for 2 years, 10 months
seen Aug 18 '11 at 22:08

Aug
18
awarded  Supporter
Aug
18
comment Suggestion for Large SQL Server Database Design
Thanks for ur input. we've applied the design principles which you're referring but will work on indexing once the development part is complete. I guess for partitioning you need Enterprise license and we've Standard edition license at the moment.
Aug
18
comment Suggestion for Large SQL Server Database Design
btw design is almost final and we're using SSRS for reporting requirements and its work great but still we're fine tuning and giving performance boost before going into production.
Aug
18
comment Suggestion for Large SQL Server Database Design
Thanks martin for your input. Actually the db contain statistics and historic record about agriculture products. The growth is substantial and your input about backup is useful. We've already planned the backup routine and your input added some great value. Our existing backup process for different database has somewhat same approach. Daily differential and weekly full backup.
Jun
1
comment Suggestion required for Large Database Optimization and performance
thanks for your links. both links give some good technical inside. We can run statistics as schedule job but it would be helpful if you've any article for comparison about performance or stats.
Jun
1
comment Suggestion required for Large Database Optimization and performance
Column-store table is the new thing for me. Let me do some research on this. thnx anyway. btw we're using MS SQL server 2008
Jun
1
comment Suggestion for Bulk Data Import
The application we're going to create is web based application where user have limited control over SQL server. User will upload the file through browser and rest of the operation will be done at server side.
Jun
1
comment Suggestion for Bulk Data Import
Actually we're creating web based application so we won't allow user to access database interface directly. Our application first import the file and then we do rest of the operation through our application.
Jun
1
comment Suggestion for Bulk Data Import
nvarchar is fine with us coz our database going to support multilingual attributes. I am reviewing the topis. thanx
Jun
1
awarded  Student
Jun
1
awarded  Editor
Jun
1
revised Suggestion for Large SQL Server Database Design
edited title
Jun
1
asked Suggestion for Bulk Data Import
Jun
1
asked Suggestion required for Large Database Optimization and performance
Jun
1
asked Suggestion for Large SQL Server Database Design