Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 SQL Server

Author  Topic 

madhulatha_b
Starting Member

22 Posts

Posted - 2004-09-23 : 03:14:49


1.We have a database of 7 lakh records or more, than how we can display so that the software will give an optimum performance.

2. If we wantto insert 14 fields of information into 14 different tables is it possible? If yes, how it can be done.

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-09-23 : 04:22:51
The performance of the query depends on factors like your table design, use of triggers.

Use Stored Procedures..

Search for articles in here.. Very useful.

- Sekar
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-25 : 02:08:30
1. You need pagination http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspx
2. You need to give more informations

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -