Am busy running DBCC ShowContig at the moment. Taking quite long.

Checked out execution plan and its shows this:

Query Cost (relative to batch) : 100%

Estimated Operator Cost: 99 %

Estimated I/O...

select top 10 * from [tablename] with (nolock)

where [Indexcolumnname] > '2008-01-01'

It takes 11 minutes to execute this query.

Yes, it works on databases on other servers but not in this particular one.

Hi Nite_eagle

Thanks for the links below....and no the table is not behind a partitioned name.

Regards

IC

Hi

I tried using this script below. But I'm getting the following error:

Incorrect syntax near the keyword 'BEGIN'.

create proc sp__Test

as

set rowcount 1000

while (select * from [Table] with (nolock) where createdt...

I am using a particular month..i just don't want the transaction logs to increase in size

Thanks... I only want to delete specific data from a particular month

Regards

Imke

I know you have an option for retention period in 2000. I am looking for a script that can do this as well.

IC

Thanks, I found a script that can do it. I just need to alter it a bit

There are jobs that run whole day. Every 5/10/20 min etc. I check some of the jobs but there does not seem to be anything out of the ordinary for...

I don't know, i was told by the sysadmin it happens at any time automatically.

Thanks, I changed the Protection level to "Do not Save Sensitive". The scheduled job is still not working.

Any ideas?

Regards

IC

Hi,

Thanks, but can you perhaps guide me step by step. I click on the package on SSIS, the properties display on th bottom right. I see Execution, Forced Execution Value,...

Jeff,

Yes, the error does display like this in the error log:

WARNING: Failed to reserve contiguous memory of Size= 131072.

Can...

Jeff,

Yes, the error does display like this in the error log:

WARNING: Failed to reserve contiguous memory of Size= 131072.

Can...