Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sethindeed

    HUGE performance problem using Find Method

    Greetings, I am using ADO objects to retrieve some SQL Server tables...However, when I am operating a Find Method, it takes awfully long time to retrieve the specific record. My tables are well indexed and only contain 6000 records. Maybe it is how I open my table. Here is an example on how I...
  2. sethindeed

    Indexing an already filled table

    Hello, I have indexed an SQL Server table that already contains some records. I have been told that I have to run an SQL prompt before the changes are applied to the table. Is it true ? Do you know what is the SQL text I have to run to optimize my newly created Indexes ? Thanx

Part and Inventory Search

Back
Top