I was worried about my Range Value in the Partition Function. I thought that the data from 2011 wont be storage 'cause the range value. So I only need to...

I do understand it. it sounds good. But that means that I need to re-create the entire shceme structure that I already have. The reason I did a monthly one...

no body ? :ermm:

it takes 2 seconds

How long does it take to insert in the base table if you disable...

actually, it takes only 22 seconds.. the problem is the insert 🙁

i dont really care that much if the server becomes unavailable for 4-6minutes, because...

thank you all.

i will try every option to evaluate business requirements.. these deletions has to be done through a UI where it cant take more than 10minutes to process..

thank...

It can be 3 million rows of 6 or 9 million rows (no more).. my cluster index can be the ID

This table will be work as a Bulk table, it will contain data that will be used in the next step of a big process. As soon as the data...

oh that was easy.. I wasnt sure about the option cause in the Job I have 4 steps..

but it worked for me..

Thank you very much !

Yes!

I need to show the 86400 seconds, even in the total of jobs are 0.

the result set that I sent it was only a sample to show all of...

I GOT IT

CREATE TABLE #jobs

(

SubJobIDINT

, [Started]DATETIME

, [Finished] DATETIME

)

DECLARE

@SDateTime DATETIME,

@EDateTime DATETIME ;

SELECT

@SDateTime = '2010-06-04 00:00:00', --'11/4/10',

...

PK is the SubJobId (for other queries)

and the index that I added for this kind of query is

Started, Finished, SubJobID

it really takes long time to execute 🙁

Okay... Im working on SQL Server 2005 and this will be the result sample that I need:

note: I only compare one minute of my entire table, but i will need...