Gail,

Many thanks for your help and advice.... just to confirm, the command you were suggesting was

ALTER INDEX IndexName ON TableName

REORGANIZE WITH (LOB_COMPACTION = ON)

Have I got this right?

Best...

It would make perfect sense, but it is outside my organisation's control.

We do have regular index maintenance - a weekly scheduled job, each sunday.

My current theory is that this isn't working, due to the presence of an ntext field in the...

The problem seems to be caused by a single ntext field in the table (horrible, isn't it!)

The stats for LOB_DATA in the Primary Key index are as follows:

Page_Count > 414,283

avge...

Hi Vultar,

We shrank it about 2 months ago, but it grows and grows.

I know the arguments against using SHRINKFILE and I don't want to use it often.

But we have a...

Hi Gail,

Many thanks for your prompt answer to my question.

The database supports a key application. Can I safely rebuild the clustered index without damaging performance for the...

Here is the CREATE statement for the table. I presume that most of the data is in the [sessdata]:

CREATE TABLE [dbo].[mdl_sessions](

[id] [bigint] IDENTITY(1,1) NOT NULL,

[state] [bigint] NOT...

Thanks, you make a good point, but there are no "blob" fields involved, in this case.

Best wishes

Mark

Dear Jan,

I have found a temporary workaround, which is to run the SSIS package on a 32-bit machine, to pull the data across from Oracle, and then push it across...

Hi Koen!

You ask a very sensible question! But yes, it is installed and running.

Hi Koen!

Many thanks for taking an interest in my problem. Here is a typical error message, AFTER I installed the 64-bit version of the Attunity Connector:

Error: 2011-05-01 07:43:05.41...

< The package was using Attunity Driver. The DBA had to install both 32 bit and 64 bit Attunity Drivers at his end. After that we were able to run...

Hi there!

I have exactly the same problem as you. How did you manage to solve it?

Best wishes

Mark Thornton

Thanks Michael, I will take a look!

Michael - Many thanks for your comments.

I realise that my paging approach is very inefficient, but the database is small. Its biggest table has less than 9,000 records. ...