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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-08 : 07:54:31
|
| Avik writes "Dear Team, Question 1I have some 1212 tables in my database .I have found some duplicate entries in the database.The software that I am using is desighned in (VB)Front End. As per my requirements how to delete the duplicate entries of these tables to improve the performance so that the reports can be displayed from the front end in the Software.It is taking 2 days to show the results which ideally should show in some minutes.Question 2Is there any query that helps us to understand which particular tables is being effected whan data is saved from the Front End.This is required as there are more than 900 tables in the databaseRegardsAvik Sen" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-08 : 08:10:58
|
1. well indexes are usefull... how much data are you showing in the report?? 2. there isn't. auditing is usefull for such things or a datetime column that tells you when the record was inserted/updated.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
1200 tables