Thanks Powell for your time .

I tried your code also but it didn't worked for me

I Hope I have not followed exact steps for installation of 7Zip software.

If you...

As suggested by you i executed the following script and received error

create table #Files (

FName varchar(1000))

declare @sCmd varchar(8000)

--use 7zip command line exe to zip a file accross file shares.

-- "a"...

Thanks Lowell,

I too learnt that usage of winzip150 needs registration,So i started using 7Zip,but i am getting

...

Hi Lowell,

When i executed the query which was mentioned by you,I got the list of files hence I hope the problem is not due to the path.

Regarding the winzip150.exe ,as...

The query just went executing not completed so i only canceled the execution

hi,

what is FileServerName means? what should i have to give in that?

Thanks Guys

Is there any way to reduce it as it going beyond the count..

I checked with as you suggested and it returning the same . what the duration accounts for?

I ran whole SP,Then what might be the reason for uncountable duration for that SP?

Is there any way to reduce the duration?

Thanks Guys

Let me explain what actually happened

We found that application was slow ,So we switched on profiler to find the slow running query.

As we measure the performance of query/SP in terms...

Thanks pradeep

Then how can we get that info. Because i have to know which indexes need to be De fragmented ,

any other ways?

Thanks Rosa,

I don't know about the availability of disks,but we want partition to improve the performance

Please suggest in this regard