Good morning George,

Thanks a lot for replying. So, it will physically shrink the file in the mirrored database also?

You are correct. It refers to the index in the attached image. Its definition is as below:

INDEX = IX_tblGPSDataDetail_DeviceID_GPSDateTime ON dbo.tblGPSDataDetails

(

DeviceID {udt_DeviceID 4}

, GPSDateTime {varchar 50}

, DataReceviedDateTime {udt_date 8}

)

INCLUDE

(

MeterStatusID...

Dear Jeff Sir, Good Morning

I tried rebuilding the index with fillfactor=80 yesterday night. I checked the fragmentation and it is 98%. I will rebuild the index with fillfactor=80 tonight.

Waittype is Latch_Ex. The processes are stored procedures(several of them blocking themselves) I read in Microsoft KB that we can ignore if waittime is low. Could you please let...

Dear Jeff sir,

I did not re-save it and nothing changed. I just waited for job to run again today to see the outcome, and it ran successfully

It ran successfully today. Thanks everyone

Thanks for the reply sir..I am not able to get why it failed. Could you please advise

I also got same error today:

Reorganize Index Description: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute...

Good morning Everyone,

I also got the same error today. Checked maintenance plan history, logs, event viewer etc but could not find anything. Could you please help

Dear Jeff sir,

Thanks a million for the wonderful explanation

Good morning Gail Madam and everyone,

Actually each SPID is blocking itself, and there are number of SPIDs like that.

Dear Jeff sir,

Thanks for contributing and helping beginner level people like me. Should the scans be lesser than seeks?

Actually, I did not understand the below statement:

" If the problem still...

Dear Jeff sir,

I have attached information of the index whose fragmentation increased to 95% the next day, after rebuilding with fillfactor=90. Shall i try rebuilding with fillfactor=80.

Dear Jeff sir,

Could you please let me know how to check how often an index is inserted

Could you please share the query to check last time when an index was rebuilt