Hi All,

I have been running this for some time now and found out that sometimes the inserts is a bit slow.

INSERT INTO DailyFeed' + @DateYYYYMMDD + '

        (

       ...

I done that, but the table is in sysindexes, even if the index has already been dropped. so it causes a bot of a problem

Hi Paul,

Thanks for the reply, this commans actually runs from Start >> Run >> And you type it in.

Very short word like that.

Thanks for the reply, let me know if you would like anything else. The code is in a stored procedure, and this update fragment is what i believe is causing...

Hello Jeff / Hello All

Thanks for your last post, I have another quick question for you, with regards to the    WITH IGNORE_DUP_KEY options, I just realized that should duplicate...

I have a similar problem with my SAN box, around 2 Terabytes, but its fragmented. Does anyone know how to go about sorting this out, the normal procedure ?

Hello  Jeff,

Thanks very much for your help, wondered how much you would charge a Trainee Developer, as you can tell from my code...

I want...

Hi Jeff,

The CDR is unique on 3 columns, so I can have a constraint on those 3 columns.

I have also sent you a Pm.

Thanks

Hi Jeff,

Thanks for your reply.

If...

Thankd for your reply JEff, with regards to naming files daily, the problem is that w eneed to knwow aht transactions came in on a daily basis, thats the reason...

Hello Everyone,

This is what i am trying to do, I hvae Daily tables that are creaed everyday.

So, once i want to do some maintainnance on the database, I want to...

Hi Jeff,

Yes, CDRFingerprint is unique on the tables.

Thanks

Hi Jeff,

Yes, CDRFingerprint is unique.

Thanks in advance

Hi Jef

The Column CDRFingerprint is the primary key, and it also holds the clustered index.

The index specification is as follows

PK_DailyFeed20060801|clustered, unique, primary key |TErminationDate, EventType, CDRFingerPrint

So the 3 keys, are...

Hi Jef,

Thanks for your reply.

To answer some of your questions, there is a Unique Clustered index Primary key on Termination_Date, so I believe this would filter out dupes.

Also, the way...