Search results for query: *

Any Suggestion guys to create new indexes

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...

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...

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...

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

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 (?,?,?)...

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...

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...