I do not believe it is that but will check. Did you experiance any kind of waits.

SELECT A.EMPLID, A.NAME, B.G5_BU, D.JOBTITLE, D.NATIONAL_ID, C.OPRID

FROM dbo.PS_PERSONAL_DATA AS A

INNER JOIN dbo.PS_TRAINING AS B

...

I see that the null is when there is no rows in the table. I ran the following and it returned 0 rows.

select i.name,* from sysindexes i join sysobjects o...

stat date is null what does this mean. if this is a problem how do I force stats update? other than what I already ran.

this is what I ran for all tables

UPDATE STATISTICS dbo.PS_EOCM_EDUP_TMP7 with fullscan

UPDATE STATISTICS dbo.PS_TL_TA_PAY_TM1 with fullscan

UPDATE STATISTICS dbo.PS_EP_GOAL_LANG with fullscan

UPDATE STATISTICS dbo.PS_GVT_ACCR_LDGR with fullscan

UPDATE STATISTICS dbo.PS_CRSE_SESS_EQUIP with fullscan

UPDATE STATISTICS dbo.PS_SAVINGS_INVEST...

Here is the 2008 plan. I can not save the 2000 plan. How do I get it? Sorry sitting in middle of another crisis aswell

The problem still persists. What I have done after upgrade.

Rebuild all indexes on tables fragmented more than 10%

Updated all stats on all tables with full scan

DBCC UPDATEUSAGE(HRTST)

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

I ran...

Hi

I did do a sp_updatestats and index rebuild. This did not change anything. I am running stats update with fullscan. I will post my findings after update and also add...

Hi

I know this is an old post but did anyone find a solution to this. Redoing all views, SPs and other scripts to optimize is crazy. I work with a...

how long does the command run before it gives error?

how are you sharing the file? Normal windows share?

make sure that the account that it runs under in maint has access to the userdb. Try removing GO between use userdb and dbcc commands

The next thing you can try is deleting the maint plan a recreating but do not create plan from remote pc, create the plan by logging on to the server...

Try changing the user the job is running under to 'sa'.

There is allot of considerations.

Do you have a where clause and joins. If so post it here so that a index recommendation can be made. In cases like this...

Hi

Anybody have an answer for me.