I think I got it, thank you

Thank you very much everyone

Not really, please explain

Thank you Jeff, I will give it a try

Ran DBCC SHRINKFILE (1, TRUNCATEONLY); with not much success. I am trying to shrink this d/b because I am taking backup of it and restoring it to another server daily.

Thanks for your reply.

You're saying:

Question you should ask yourself is 380GB a problem? Properly maintained it's quite possible your DB will never grow anywhere near that size and...

Thanks, but it was/is enabled

Since I asked a question, I just couldn't find a native to sql server solution that would work and will be easy to implement.

My data (json) is coming from...

Thanks Jeff,

2008 server (A) runs under "local system" account

2012 server (B) runs under "qa" account

Do I need to add "local system" to the "administrator" group on server B?

Thanks,

Thanks for reply, but I wanted the result to state:

A 9.5

B 4.5

C 2.5

as I think it is 90th percentile for each DEPT

Thanks for reply. I just found this same article.

Problem is: I am going to have millions of records in json format and wonder if it would work because of what...

Thanks for reply. How can I check that?

--drop table ep

create table ep (text varchar(100))

insert into ep values (

'german

shepherd

dog'

)

select ?????

update:

I see it now. I redirected output to text and see that...

Thanks Greg. I am not familiar with SSIS ... yet. Will have to look into it.

At this point, I simply look at the job history to determine the max time it ever ran for.

Not ideal, but it works.

Thanks for reply, but each job has different "normal" execution time, so a proposed query won't work.