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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by abkad

  1. abkad

    Optimal indexes for these queries

    Any Suggestion guys to create new indexes
  2. abkad

    Optimal indexes for these queries

    These are the execution plan for the queries in the first reply |--Stream Aggregate(DEFINE:([Expr1003]=MAX([STATUS].[TIME]))) |--Top(TOP EXPRESSION:((1))) |--Clustered Index Scan(OBJECT:([STATUS].[PK__LOADERWATCH_LOAD__2779CBAB]), ORDERED BACKWARD) |--Clustered...
  3. abkad

    Optimal indexes for these queries

    indexes on status PK__LOADERWATCH_LOAD__2779CBAB clustered, unique, primary key located on PRIMARY TIME, COUNTRY, NAME indexes on files LLQ_K1 nonclustered located on INDEXES NAME, TIMESTAMP LLQ_K2 nonclustered located on INDEXES TIMESTAMP,FILE_COUNT LLQ_K3 nonclustered located on INDEXES...
  4. abkad

    Optimal indexes for these queries

    HI All, I have the following queries are still running slow eventhough I added some indexes it didn't get the indexes and still giving me table scan and table delete. Have the following 2 tables each have more then 20 million rows. CREATE TABLE [dbo].[STATUS]( [NAME] [nvarchar](10) NOT...
  5. abkad

    PreparedStatment Batch with more than 1 query

    HI bborissov, could you be more clearer how to do that? Thanks..
  6. abkad

    PreparedStatment Batch with more than 1 query

    Hi there, I have the following preparedStatement: PreparedStatement proPreStProdProperties= connection.prepareStatement(" " + " DELETE FROM properties" + " WHERE id_itm = ?" + " " + " INSERT INTO properties " + " (id_itm,property_key,property_value) "+ " VALUES (?,?,?)...
  7. abkad

    Speed up insert and delete Queries

    Well I can say it is a throughout day exceution since files are frequently pushed to be processed to delete old data and insert new. the index strategy is well done on the table. But since I have too many deletes and inserts that causing the problem so I am looking into a startegy that can speed...
  8. abkad

    Speed up insert and delete Queries

    Hi all , I am loading data files intp Sql server 2005. I must delete then insert a large number of rows into tables. The Queries for examples are Delete from customer where name='John' and country='US' . . Insert into customer values ('John','Bray','US') Insert into customer values...
See more

Part and Inventory Search

Back
Top